Individual Customer Report
Hello,
I have a smartsheet form and sheet that I have created reports and dashboards on. The form has many submissions from customers. Many customers have made multiple submissions to the sheet. I would like a report that shows how many individual customers have submitted the form. Is there a way to create this? To note, the customer identifier is the Primary field.
Answers
-
Hi @Fiona Murray , There are several ways to do this, so I'll offer you three:
1) Create a Sheet Summary formula that uses COUNT() and DISTINCT() functions. You could put other related data within this sheet summary too, like how many total rows, etc. This is the icon for the sheet summary (on the right panel)
2) Create a report and Group based on Customer identifier. You could use the Summarize feature to count the number of submissions for each customer or other statistics. You'll get a grouping of submissions for each customer. This doesn't return the number of distinct customers per se, but it may be useful for your purposes.
3) Create a separate sheet that uses COUNT() and DISTINCT() with cross sheet references to the customer column in your original sheet. You can calculate other summary date in this way too.
Depending on what you are trying to do, one of these approaches should work fine for you.
Be well
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives