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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!