I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status.
Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does not want to have an overall document that everyone can access! In this case I would have just set up filters and everything would have been fine, but not now.
During the running event I need to receive live status updates from the teams on site. This is the reason, why I think reports will not work here.
Looking forward to reading your feedback and say thx in advance!