I am using Smartsheet for project planning.
I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separately as a percentage so I can see what percentage we start and finish to plan when it happens.
I have created an Ancestors column to help identify levels of work in the sheet with the formula: =INDEX(ANCESTORS([Task Name]@row), 2).
However I am having trouble with the formula in the overall sheet summary. Can anyone help?
The output should look like this:
Overall Start to plan: **%
Overall Finish to plan: **%
Help Article Resources
Check out the Formula Handbook template!