This is my first post. I hope there's some people who can help me.
We have 7 PC's in our office. We use Google for Business.
We have a factory floor that we'd like to communicate upcoming orders for our factory staff to see. This would save our staff running out to the factory floor with bits of paper, the paper then getting lost etc etc.
Any one of these 7 PC's could login to a shared Google Sheet, and then update our order list. What I'd like to know, is what is the best or most economical way of getting all those PC users to update the same sheet which would appear on the large monitor we have in the factory floor.
Our factory floor staff need only have read only access to this sheet, and do not need to change it. Only our office staff change the order list.
We can move away from Google Sheets or this model if someone has a better idea on how to do this.
Thank you in advance.