Formula to auto fill cell's in a column going downward in a row.
Hello
I am looking for a formula that will autofill totals in column5 going downward in a row so filling column5 row 1, row2, row3, etc. The information comes directly from Column2 automatically and gets filled weekly with different data. Please see image.
All feedback is welcomed.
Thanks again.
Answers
-
This is the formula I am using in to total the amount in column 2 =COUNT([Column2]:[Column2])
-
Hi @Cristian
Formulas assess current information and aren't able to time-stamp or pause a result at a specific point. This means that when Data Shuttle updates the sheet, the formula will update to reflect the new information.
If you're on an Enterprise plan, you could look into using the Work Insights panel to track changes to data over time in the sheet. You could have a Time Series chart based on Column 2 to see how many 1's are in that column week over week or month over month, etc. See: Use Work Insights to visualize your data.
Let me know if that will work for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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!