how i can SUM Childern when a #NO MATCH error is at the column ?
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
Hope this helps
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Hi - We number tasks in our Smartsheet grid using the format XXX.X. When we sort in descending order, the numbers are not in order. For example 200.0 appears below 001.0. Since it is in descending order 200.0 should appear before 001.0. We also want to start using four digits before the decimal point and want to know if…
I would like to have my note column auto size so that the note when longer then the cell it in, can be read in its full txt and not disappear under the next column
Good day Smartsheet Support How do I Riana this account user change my account credentials to another username and password. I am not using this account, but my college is using this account with my credentials. Can you please assist me in how to go forward by changing my account credentials to another users' credentials.…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.