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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives