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 ?

Stefan

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