Days overdue count, only when Overdue Cell has Red Symbol

Shannon W

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.

Kelly Moore

Hey @Shannon W

This should work for you

=IF([Overdue?]@row="Red", TODAY()-[Due Date]@row)

Does this work for you?

Kelly

Kelly Moore

Hey @Shannon W

This should work for you

=IF([Overdue?]@row="Red", TODAY()-[Due Date]@row)

Does this work for you?

Kelly

Shannon W

Hi Kelly,

Thanks so much, it worked a treat.

Much appreciated!!

Shannon