Trying to create Cumulative Flow chart from task list
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?
Comments
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!