Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project.
My problem is that while I can manually set this for the rows, these sheets are touched by several people and they are often not setting said formula and I don't want to have to keep manually fixing it. So I was hoping there was a way to automatically set anything with a blank hours to be something like =IF(SUM(CHILDREN()) > 0, SUM(CHILDREN()), "") (I do this bc I don't want things to get set to zero if they haven't been estimated yet).
I was hoping to do this with automations, but it seems like there isn't a way to automatically update a cell with a formula. Is there any way to do this? Can I set some type of default value for a column?
I'm somewhat familiar with the API so my only other thought is to write some code to do this, but if there is any way to do it from smartsheet itself I'd much prefer that.
Thanks in advance!!
