I'm going nuts. I can't seem to figure out a simple formula that is essentially "sum of children, but don't factor in any children with negative values".
Can someone please help?
Hey @Nicole J
Give this a try
=SUMIF(CHILDREN(), >0, CHILDREN())
Hi @Nicole J
Use SUMIFS to set criteria only sum positive value:
=SUMIFS(CHILDREN(), CHILDREN(), >=0)
You're all lifesavers. Many thanks. Mission accomplished.
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.