SUM CHILDREN if a #no match error in the column
Sandro Carlo
✭✭✭
Dear Community,
how i can SUM Childern when a #NO MATCH error is at the column ?
Answers
-
Hi @Sandro Carlo,
you should modify your formula in the column with the error. Once there are no errors in your column your SUM Children will work.
Try to use IFERROR
https://help.smartsheet.com/function/iferror
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives