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!
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…
