Days overdue count, only when Overdue Cell has Red Symbol
Apologies for asking what must be a very rookie question, but very fresh to Smartsheet and I'm stumped and can't find an answer in previous posts.
I am needing to calculate days over due in my 'Help Days Overdue' cell ONLY if the 'Overdue' Symbol is Red.
Any help here would be much appreciated while I try and bring myself up to speed with formulas.
Best Answer
-
Hey @Shannon W
This should work for you
=IF([Overdue?]@row="Red", TODAY()-[Due Date]@row)
Does this work for you?
Kelly
Answers
-
Hey @Shannon W
This should work for you
=IF([Overdue?]@row="Red", TODAY()-[Due Date]@row)
Does this work for you?
Kelly
-
Hi Kelly,
Thanks so much, it worked a treat.
Much appreciated!!
Shannon
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!