If you have a status that is "Not Applicable"; what is the best practice for assigning % complete to that activity? I have been assigning it as 100% but I don't think that is correct as if just starting a project, the % complete, where there are activities that are "Not Applicable", the % complete would show greater than 0, which would not be correct.
Since % Complete is rolled-up within Smartsheet, how can it essentially ignore counting activities whose status is "Not Applicable"?
Help Article Resources
Check out the Formula Handbook template!