Days overdue count, only when Overdue Cell has Red Symbol

Shannon W
Shannon W ✭✭
edited 09/03/21 in Formulas and Functions

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.

thid.PNG


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!