Indicating a row is past due

Hello everyone,

I was wondering about a capability in Smartsheet.

I was hoping to indicate a row was not completed on time. I am not talking about conditional formatting per say. I do not have a preference how this is shown but I was thinking of a function where a cell column of that row is in red? This Smartsheet is used for customer requests and every row is a request so I would like it to be known if a specific request was not completed on time.

The columns we have set up is: Date Received, Due Date, Date of Closure.

Let me know if more context is needed. Please help. Thank you.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!