Trying to create Cumulative Flow chart from task list

edited 12/09/19 in Formulas and Functions

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


    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:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!