Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Dynamically update dashboard after form submission
I am experimenting with the Sights feature, and attempting to have my dashboard update whenever a new web form is submitted. We have some metrics that are manually updated every week, and I'm hoping to auto-populate an overall view.
However, a new form submission doesn't update any of the numbers in my Sight, they are stuck on the old numbers even though there are new, updated numbers in the sheet & cells I specified. I'm not sure why not. Any insights?
Comments
-
What I have done is built in hidden count formulas on the sheet where the webform is populated. When the criteria is entered (which you can control by using drop down menus on your webform) on the webform the count formula will update the Sight.
-
Could you please share an example of this? Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives