Prioritising responses
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.
Thanks everyone!
Comments
-
Hi Kylie
To accomplish this, please follow these steps:
- open the report that you are using in the Dashboard
- right-click on the column-header titled "Modified" (as in your case); a context menu will appear
- choose the option "Sort Report..." from the context menu (please see attached screenshot titled "report context menu")
- in the Sort Report dialog that appears now, choose the column-name "Modified" in the top-level drop-down list titled "Sort items by:" (please see attached screenshot titled "report sort")
- ensure that the radio button "Sort Ascending" is selected next to this drop-down.
- Click OK to close this dialog and press CTRL + S to save this report.
- that's it!
Now when you will include this report in your dashboard, it will always show you all the rows in "oldest on top" order.
Hope this helps!
Best
Nasir
-
Hi Kylie,
You could use a report that is sorted by Modified.
Would that work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives