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:
https://calendly.com/sam-samharwart/30min -
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
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives