I am trying to add a simple status ball of red or green if a task has missed its end date
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: