I cannot get my IF statement to automate Harvey Balls.

MDriggs ✭✭
edited 07/07/22 in Formulas and Functions

Hello. I have used RYG balls before to show statuses for dates. But I am wanting to use them based on the value of a single cell. I have tried various formulas but they are not working. Would anyone have advice on this? I have included a screenshot with the formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!