IF formula return RYG symbol based on Status

Hello - I am very new to Smartsheet and am trying to write what I think is a simple formula, but I keep getting an Incorrect Argument error. This is what I need:

If Status = In progress, green ball

If Status = On Hold, red ball

If Status = Complete, grey ball

If Status = Not Started, yellow ball

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!