Sign in to join the conversation:
I would like to automate the RYG balls in my sheet to turn “Green” if the Due Date is in the future, “Yellow” if the Due Date is today, and “Red” if the Due Date is in the past. Is this something Smartsheet can do?
Hi Travis, your formula worked great, thank you. I have a "Status" and "Status Update" column. I put your formula in "Status Update" column. The "Status" column is a dropdown for not started, in progress, on hold, and complete. How do I add to your formula to only use RYG balls if the "Status" is not started or in progress?
