Sandra_Mayernik - profile

Sandra_Mayernik · Jul 23, 2021

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...

Sandra_Mayernik · Jul 23, 2021

OMG! There was an extra space after the ord in the Single Select option… once I got rid of the extra space, the formula worked perfectly! Thank you!

Sandra_Mayernik · Jul 23, 2021

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.

Sandra_Mayernik · Jul 23, 2021

Kamille_Parks: SWITCH( {Gravel Layer Rati...}, "EXCELLENT", 10, "GOOD", 7, "FAIR", 5, "DEFICIENT", 3 ) Thank you! We’re getting closer !

User Statistics

User Activity

Calculate a number based on selected single select option

Re: Calculate a number based on selected single select option

Re: Calculate a number based on selected single select option

Re: Calculate a number based on selected single select option