Sign in to join the conversation:
New feature request posted here:
http://ronin-global.com/2018/08/05/smartsheet-enhancement-request-branch/
Craig
Hi Craig,
It sounds like you're looking to reference all children and children's children all in one formula.
As you may know, the best way to do this currently is to add SUM(CHILDREN()) or COUNT(CHILDREN()) in each parent row and then SUM or COUNT the CHILDREN in the parent-most row (Ancestor 0).
I typically try to lock these sorts of parent rows to prevent people from editing them. That way I can chase down any admins that may have inadvertently broken my sheet.
Yes, Shaine, I am.
The use case where I ran into it was JOIN(COLLECT()), which quickly clutters up the Sheet with useless cells. At least for COUNT or SUM, each level has meaning and usefulness.
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
