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