At Risk Flag & IF Function

brandi.meyer80376
brandi.meyer80376 ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to set an IF function to the At Risk column.  I would like it to flag if the end date is within 2days or if the % complete task is less than 80%.  Can someone help me set that function up?

This is what I am putting in; 

=IF(AND([End Date]3 2>=TODAY() + 1, [% Complete]3 <.8) 1, 0)

«13

Comments