Sign in to join the conversation:
Hi,
I want to report on the number of form submissions in a dashboard - can anyone tell me if this is possible?
Many Thanks
Hi Emma,
Yes, it is possible. How to set it up depends on your specific use case.
One way to do it would be to count the rows with submissions. If the sheet is combined with submissions and other rows you could use a predefined field from the form that is hidden.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
You could use a COUNT formula that will tell you how many rows are not blank which would only be the ones auto-populated by the form submissions, then use a metric widget on your dashboard to display the result of your formula. That would give you a live count.
Thanks that's perfect
Great thanks for the advice, all in place now
Happy to help!
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
