Find information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.
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?
What about working between a start date and end date? Seems like I need an "and" statement?
I have used this so much.
Good Post!
Thanks Travis! This is perfect!
Good question, Greg! Using formulas, you can automate RYG balls to change colors based on multiple aspects of your sheet, including the Due Date.
Here’s the formula that would be added to a RYG cell that will show “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:
=IF([Due Date]1 < TODAY(), "Red", IF([Due Date]1 = TODAY(), "Yellow", IF([Due Date]1 > TODAY(), "Green")))
In this formula, Due Date is the column name and the 1 is row that contains the formula. This formula’s cell references would need to be updated to match the data (column name / row number) in your sheet.
Here’s information from our help center on formulas: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas
And here’s a blog post on automating RYG balls: http://www.smartsheet.com/blog/support-tip-automate-RYG-balls
