Trying to create Cumulative Flow chart from task list

cbaetz

I am attempting to build a cumulative flow chart based on new, active, closed tasks. The struggle is coming from trying to build a sheet with formulas that will pull the information from the task list and hold onto the information moving forward. Once the formula finds the correct data it continues to update each cell with the new information. Is there anyway to lock a cell once it has data filled in from a formula?

Shaine Greenwood

Hello,

There currently isn't a way to lock a formula or stop a formula from working at a certain point.

You may want to consider utilizing an IF statement or nested IF statement in order to refine the criteria that triggers the formula to work. You might consider also using SUMIF, SUMIFS, COUNTIF, COUNTIFS to refine criteria as well.

Details on all of these functions can be found in our help center: https://help.smartsheet.com/functions