Formula to highlight a column in RED when date is past the task end date and progress is <100%

Options
BobbyS
BobbyS
edited 03/03/21 in Smartsheet Basics

Here is what I have:

Any time the task end date is past today's date and the progress is less than 100% complete, I want this to be highlighted in red. Below is the formula I am using but it does not seem to work. Please help.

=AND(date>=task_start, date<=task_end,task_progress<0.1)

Date = the weekly dates in the row in BLUE (1/4, 1/11 etc)

Task_start = Start column

task_end - end column

task_progress = Complete column


Answers