Announcements
Hello, I have created a section in the Opportunity form that has different drop down fields ranging from 1 to 4 to grade project size etc. I want to know is it possible to take the values from each of the 4 Grades, to calculate the overall grade and display it within that text box?
Hi @phull5431
The easiest OOTB solution would be to use numeric fields instead with min value set to 1 and max to 4. You could use the field's 'Description' box (e.g. Rate the Grade from highest 1 to lowest 4) or the field label itself (e.g. Builder Grade (from 1 to 4)) to guide the users that they need to rate between 1 and 4.
The overall grade can then also be numeric calculated field.
You'd still have the challenge that you'll still be required to provide a logic that if any of the fields are empty then it amounts to zero for that field when calculating the total.
I hope this information helps. If my reply addressed your concern then please give it a thumbs up and accept it as a solution.
Kind regards
Gulshan
@phull5431
Calculated field will not work in this situation.
I had a similar problem before and since I had to use option set so the alternative way I used a power automate to calculate the score and update it back to the field where I need it to appear.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
