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
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives