Formula not working for creating a score in a survey

Options
✭✭
edited 10/25/23

=IF(OR([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1), IF(OR([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2), ([is the agency's experience with local, state or fe]@row = "> 5 years",3)))

I'm willing to change the formula completely if there is a better form or function to accomplish getting the score.

Background: I have a survey and there is a drop down where the survey taker can choose three options and get a score based on which one they select.

👀

Answers

• ✭✭✭✭✭✭
Options

Try: =IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, 3

• ✭✭
edited 10/25/23
Options

This really helped!

THANK YOU!!!!

Here's the final working solution:

=IF([Is the agency's experience with local, state or fe]@row = "≤ 1 year", 1, IF([Is the agency's experience with local, state or fe]@row = "≥ 5 years", 2, IF([Is the agency's experience with local, state or fe]@row = "< 5 years", 3)))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!