I am trying to add a simple status ball of red or green if a task has missed its end date

Cathy Wagner

I'm new to Smartsheet and want to identify tasks past due. If the End Date is less than today and % Complete is not 100%, the On Track cell should show a red ball, else a green ball. I may want to add yellow at some point, but haven't figured out what the driver would be.

Can someone help?

Here's a snap shot:

Kelly Moore

Hi Cathy

Try this

=IF(AND([End Date]@row<TODAY(), [% Complete]@row<1), "Red","Green")

If you determine the yellow trigger, you'll add that IF statement before the , "Green"

Let me know if this doesn't work and we can tweak it

Kelly Moore

Hi Cathy

Try this

=IF(AND([End Date]@row<TODAY(), [% Complete]@row<1), "Red","Green")

If you determine the yellow trigger, you'll add that IF statement before the , "Green"

Let me know if this doesn't work and we can tweak it

Cathy Wagner

Perfect. Thank you so much!