Sign in to join the conversation:
Hi,
I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column.
Can anyone help??
Thanks,
Bill
Hi Bill,
Try this out:
ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)
Best,
Kara
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?
