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.
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…