Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding.
In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week, they say Completed 0 of 0. Is there a way to update this formula so that it will summarize all of the tasks for the week and show how many are completed: total of Total for that week? I can do if if i just add my exact range, but would like it to reference all of the children and grandchildren tasks automatically for that week, since each week will have a different number of tasks as the plan is built out.
="Completed: " + COUNTIF(CHILDREN(Done11), 1) + " of " + ((COUNTIF(CHILDREN(Done11), 1) + (COUNTIF(CHILDREN(Done11), 0))))
Not sure if you can see the template I saved down in my Workspace, here's the link:https://app.smartsheet.com/sheets/VgcRFW9QqWC4Mw2WgXR2pwjPQ8jmhgcxRFP8qGg1
You can also find it in the solution center: Template Set- New Employee Onboarding
Help Article Resources
Check out the Formula Handbook template!