I just want to have a running count of entrants in a column so that I can pull this data to a dashb
I just want to have a running count of entrants in a column so that I can pull this data to a dashboard. I have been playing around with the sum and count and sumif and countif functions. I want the data to be live so that is another person submits the form (the data is from a checklist) the dashboard widget will update too.
Answers
-
Hi @boston_123 ,
You could add an auto-number column to create your running total and a sheet summary value to find the MAX() of the column. Thoughts?
Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing? Grab time on my calendar here: Schedule a Discovery Call! -
Thanks. I inserted a column to the right of the one I want the running count on and formatted it as auto number. What is the next step with that column? When I click the summary sheet icon to the right and open, what is the formula I should enter? Also, I attached a screenshot of the rows of space between rows 7 and 8 - I wonder why that is happening? I dont see any data in that spatial area. Do you give tutorials?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives