Auto adding Cells to one singular Cell when a column is triggered.
Hello,
I am trying to figure out how to Add cells to another cell when a column is triggered. I have a column of numbers that I need to add to another cell as soon as that row changes to another statuse. For example; The Statues column, when it changes from drafting in progress to drafting completed. I need a cell in that row to automatically add the amount to Service Group/2 cell to get a total amount of drafting work that is completed so far in the footage column.
Yellow is trigger/Blue is the number that needs to be added/Brown is the single cell I need all the footages to add up to once yellow is triggered.
Answers
-
Hi @C_Herrell are you looking for a total of all of the Drafting Complete rows? If so, put the following formula in your Service Group Column in row 2
=SUMIF(Status:Status, "Drafting Complete", Footage:Footage)
When the Status of your rows gets updated to "Drafting Complete", the Footage will be automatically added to the total in row 2.
Is that what you were going after?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!