Split-screen auto populate?

Thurston64 · 03/25/19

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?

Paul Newcome · 03/25/19

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?

Andrée Starå · 03/26/19

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

Thurston64 · 03/27/19

Paul,

I'm going to try this out today. I didn't think to use widgets, thanks!!

Paul Newcome · 03/27/19

Let me know how it works out for you.

Split-screen auto populate?

Comments

Help Article Resources

Categories