RYG balls & Dates

Leslye Jackson
edited 07/16/20 in Formulas and Functions

Hi All,

I am working on constructing a formula that will automate based on the dates (Start Date, Due Date and Complete Date) I can get the balls to automate using one color or another but not all four within the same formula. I keep getting an unparseable or incorrect argument error. The below formula actually works however it wont allow me to do another If statement for the Green & Yellow balls. Any feedback is very much appreciated.

=IF([Complete Date]20 > [Due Date]20, "Red", IF([Complete Date]20, " ", "Gray"))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!