This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I need to calculate a number based on selected single select option in another field.
For instance if the users chooses “Excellent” then the number should be 10, if the users chooses “Good”, then the number shoud be 7, if the users chooses “Fair”, th...
Thanks to Kamille for the formula
SWITCH(
{GRAVEL LAYER RATING},
“EXCELLENT”, 10,
“GOOD”, 7,
“FAIR”, 5,
“DEFICIENT”, 3
)
Though I’m still trying to figure out why “Excellent” and “Fair” don’t generate a number.
