Managing task and % complete column

sistecompanama74176

In a project I have task for doing, but on the way, some tasks will be cancelled for any reason: the client suspended, its not necessary now or for any reason. My question is, I need put on the % complete cell a 100% completed?? for me its not logical to do that but If I dont do it the average on my principal row will be affected. can you help me with some advice about this??

thanks

I dont have any start time or end time because this task are cancelled.

jg124

You could have % Complete turn blank (" ") if the event is cancelled for whatever reason. This also won't affect the overall average.

For example =IF([Estatus]1="Cancelled", " ")

Hope this helps :)

sistecompanama74176

thanks for your comment but the formula dont work. May I put it in a wrong cell.

Andrée Starå

Hi @sistecompanama74176 ,

Did you get it working?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lisa_Doris

I have the same experience. I change it to 100%, my thought process is if its cancelled- its done- therefore no more work is necessary=100% complete. If its on hold I assign either 10% or 25% to that row and flag it.

I also use a formula in the percent complete column to trigger a certain percentage when a status or criteria is met, this is useful, sometimes people just don't change the % column