SUM CHILDREN if a #no match error in the column

Sandro Carlo

Sandro Carlo ✭✭✭

08/11/23 in Smartsheet Basics

Dear Community,

how i can SUM Childern when a #NO MATCH error is at the column ?

0 ·

Answers

Stefan ✭✭✭✭✭✭

08/11/23

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.
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

MS Project Import Question
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
Card View: Can't sort by desired category
I would like to use card view for one of my sheets - and sort it by the "type of service" that was performed on our equipment. For some reason, I am able to sort my cards by literally every category but that one. The column is a drop down menu. Is that the reason I am unable to sort by that category? Not sure why I…
Summary Function Between Business and Pro
Apologies if this is the wrong area to post this… I am a one-person shop that uses Smartsheet to manage various tasks. One of these is the PTA where I volunteer as a board member. I would love to use the dashboard feature to track certain metrics (parent attendance at events and our performance in fundraising) and show…

Help shape the future of Smartsheet.
Share your ideas and feature requests.