Hi SS guru's!
I'm looking to create a dashboard that essentially visualises a list in priority order, based on the time we receieve a form response.
So far I have a sheet where responses are logged, and we use system generated modified (date) to log the date and time we recieved the confirmation.
What I want to do is create a dashboard showing these entries in order of being modified - oldest at the top, newest entry at the bottom.
Any ideas on what formula's etc I'd need to make this happen?
I've attached a screen shot of the information i have.