UWSOM-EQI’s Profile

Community member since April 2019

points
16

3

I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. 

=IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal"))

I want the sheet to check if a task is not yet marked complete