IF AND date issue

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


I hope you can help please.

We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week.

I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work until there is no date specified. 

The formula I have used is: =IF(AND(Start9 - 5 < TODAY(), Priority9 > 1), "Red", "Green")

Can anyone help with the formula/expression I should use please?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!