Hi Everyone,
From my point of view this is very complicated to work out so i will try and simplify it as small as possible.
People visit site locations on a monthly basis. I want to show on a smartsheet dashboard what sites need to be visited when there is only 1 visit on the site and that date is about to run out of the 30 day rolling period.
This is a photo of where the data is collected and you can see there are repetition on sites within an area of time. This can be called Sheet 1
In Sheet 2 is where all of that repetitive data gets collected within a 30 day period.
What i would like to happen is that when a location such as Aberdeen - Westhill has 1 site visit and that visit is 23 (out of 30) days old to put into a new cell somewhere to visit Aberdeen - Westhill.
The final goal is to be able to display this automatically on a Smartsheet Dashboard when a site is about to go to 0 site visits within the last rolling 30 days.
If anymore information is needed reply to this post and I will reply back as quickly as possible.
