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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!