Indenting on smartsheet causing calculation error- help?
Hello,
My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my case specifically, =((8 * 5 * 7) - SUM(CHILDREN())) )
If a work order has multiple operational steps it is included in the smartsheet for visibility/counting hours, but then indented for a cleaner view. It has been discovered that the calculation is affected by the indentation. See in the below screenshot the black box- those two lines are the same work order, the second line with 2.6 hours is what is indented. If outdented the available RE's changes to 77.5, but if indented (and as shown in the screenshot) it reflects 80.1 hours.
How can this be corrected so that the formula is calculating all hours, even if the line is indented?
Help!
Best Answer
-
Hi @snhawkin ,
You will want to use the DESCENDANTS function. This will allow you to sum all children and grandchildren (and any great-grandchildren, etc.) - anything that is a descendant of the parent row.
Hope this helps! Let me know if it works.
Best,
Heather
Answers
-
Hi @snhawkin ,
You will want to use the DESCENDANTS function. This will allow you to sum all children and grandchildren (and any great-grandchildren, etc.) - anything that is a descendant of the parent row.
Hope this helps! Let me know if it works.
Best,
Heather
-
-
@snhawkin Great! So glad it helped. Have a great week.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 440 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!