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.

Symbol Function

IF([CEO Approval to Close]@row = "Approved", "Red"), =IF([CEO Approval to Close]@row = "Declined", "Yellow")

I am trying to get it so that if approved the symbol is the red circle, declined as yellow. If I only have the first part in the line it works, but when I try to add in the declined piece I get error messages. What am I doing wrong when trying to combine multiple IF functions?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions