Set up conditional formatting in dates, with additional variants

I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"?

So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2 days, turn Due Date column red.

Is this possible?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!