Split-screen auto populate?
Hello all!
I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the sheet, taking up space and leading to confusion.
My question is, is it possible to have a horizontal split view that auto-populates those completed items onto the bottom half of the screen once it's marked as complete at the top?
Comments
-
You could create a filter on the main sheet that only shows lines that haven't been marked as complete. Display the published sheet on the top half of a dashboard using a URL widget. The bottom half of the dashboard could be a report that pulls all lines that have been marked as complete. Set the dashboard to refresh every minute.
Does this sound like it could work?
-
Hi,
I agree with Paul, and I think that would be an excellent solution.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Paul,
I'm going to try this out today. I didn't think to use widgets, thanks!!
-
Let me know how it works out for you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!