Flag if date created > 48 hours and completed column is blank

yheng ✭✭✭
edited 12/09/19 in Formulas and Functions


I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias:

1. if the date created has been more than 48 hours

2. and completed is blank (not marked with a date)

Basically in terms of workflow automation, when a request is submitted and the other team has an SLA of 48 hours and hasn't completed the request yet, the row will be flagged/highlighted.

Thank you!!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!