Sign in to join the conversation:
I have a task with subordinate tasks, the highest level is not calculating with the rest of the sheet. I have precisely the same setup throughout the sheet and the rest work. Any ideas?
Hello,
Thanks for this question! Could I have you check that dependencies are enabled on the sheet? I would assume so because your other "% Complete"s roll up, but I just wanted to verify.
Secondly, could I have you provide a full-sheet screenshot of what you're seeing on the sheet? If needed, you can black out sensitive information such as email addresses.
Kind regards,
AlisonSmartsheet Support
I have the same issue where parent lines do not calculate child percent complete into the summary parent line. I've tried using both dependency enabled and disabled.
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…