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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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!