On Time and Past Due Formulas
I am trying to create a formula in Smartsheet that replaces a formula we are using in Excel that turns a cell red or green if the date entered is before or after a referencing cell date. If that makes sense.
So – If the Review SOW date cell in a column is in the past and the Review SOW Complete cell is blank, that cell and/or date will turn red and stay red even after a date is entered because it was past due.
Then, if the Review SOW date cell is either in the future and the Review SOW Complete is less than or equal to the Review SOW date, then that cell turns green after a date is entered.
We currently have this built into Excel but would like to move it to Smartsheet. We report out on metrics on how many milestones are on-time vs late but we need something that shows this visually in our tracker.
Any help or suggestions would be greatly appreciated because I'm stumped at the moment. Thanks!
Help Article Resources
Check out the Formula Handbook template!