Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Use Formula to Assign Dropdown Selection in Column

I would like to have the column titled Alert Level return a symbol from the dropdown menu based on the number of selections in the Alert column.

I'd like the symbol to be green if there the Alert column for that row is blank. Blue if there is 1 item in the Alert column, Yellow is 2 items and Red if there are 3 or more.

Is this possible?

Gillian

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions