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!
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
Smartsheet is currently combining my automated emails from multiple lines into a single email. Is there a way to force each line to get its own email? I have column placeholders in the subject and body of the message, but it always combines lines into a single email when the automations are triggered at the same time for…
I've rebuilt my form at least five times and for the life of me cannot figure out why it will not trigger. I've tried to test and run it several times to no avail. Any tips would be very helpful. I was able to successfully trigger once, now nothing at all for a week.
