Managing task and % complete column


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??


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!