I'm a teacher creating a "didactic deck" for my students: https://docs.google.com/spreadsheets/d/1j7iJTlRXl24YwUt4zKJdTfNencd_u3RUosRdiWZ8YbE/edit?usp=sharing
The first sheet has 5 "cards" randomly taken from the other sheets. Since most of my students will access the deck from mobile devices, the problem is...
- I couldn't find a way to refresh the sheet from a mobile device.
- I've added a drop-down data validation on A1 to make the trick, which it does, but it also changes the "cards" for another person who is seeing the page on a web browser, for instance.
Then, the question: - How to refresh a sheet (or even a cell) on a mobile device without refreshing it for another viewer on another mobile or web device?