Is there a way to produce a live dashboard?
HI All,
I am fairly new to Smartsheets and looking to build a live dashboard for my companies control centre.
We are a security mobile patrol business and when our guys go to a clients site to patrol they log their visit via a form on Smartsheets.
What we need is for sites that aren't being visited frequently to flag up so we can send a patrol out. I can set alerts for every time a cell changes/form is submitted however I almost need the opposite here.
Any ideas?
Best Answer
-
If you create a master list of all sites, you can use a formula with cross sheet references to pull the date of the most recent entry for each site from the form sheet. From there you can set up an automation to run based on the "most recent visit" date being too far in the past.
Answers
-
If you create a master list of all sites, you can use a formula with cross sheet references to pull the date of the most recent entry for each site from the form sheet. From there you can set up an automation to run based on the "most recent visit" date being too far in the past.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives