RAG status based on dates overdue
I'm attempting to get an output of either, "On Track", "Overdue" or "Critically Overdue" for baseline milestone dates in Smartsheet, with the Overdue being 5 days over & Critically overdue being 20 days over respectively.
I have drafted the initial IF statement, however i'm suck on how to add the additional "Critically Overdue" parameter and how to add the 5 & 20 days threshold.
=IF([Baseline Date]@row = [Actual Date]@row, "On Track", "Overdue")
Any suggestions would be appreciated!
Help Article Resources
Check out the Formula Handbook template!