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

Unable to change the colours on charts/widgets
Hello Everyone, I have some dashboards created and it seems that since this morning all the charts colour changed colour even though the correct colour is selected: I went to the Smartsheet status page and it seems all status are running normally. Anyone having the same issue? Many thanks Mariana
Automation Not Working – Status Not Updating Automatically
Hi Smartsheet Community, I’ve set up an automation rule in my Smartsheet to automatically change the "Status" column to "New" when a new request is submitted via a form. I followed these steps: Created a "Status" column. Set up an automation rule triggered by "When a row is added." Chose the action "Change cell value" to…
What causes parts of my sheet to flash?
I no sooner changed a date and parts of my sheet started flashing, any idea why?

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