I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated?
The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start
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,