Hi Guys, Apologies if this is a basic question. I'm used to Excel and VBA, which I cannot utilise how I want to in Google Sheets.
I have a form linked to a hidden spreadsheet to record responses. I've added a column with tickboxes. When ticked, I want the information displayed in another spreadsheet which is viewable by the public (who have the link).
I have 2 queries. 1 I'm sure is easy, but I'm missing something obvious. The 2nd is probably impossible given Google Sheets limitations.
1) The way I have the data linked now basically goes; If A2 is ticked (TRUE), then A2 on public sheet = B2 on hidden sheet (same heading just offset by the column with tick box). And dragged along to fill columns. Sweet. This works well. However, when I have (for example) Row 13 unticked, it leaves the row blank in the public sheet. Is there a way I can put this information into the public sheet and skip blanks? Ideally the filter options in the public sheet will not show blanks as an option too. Also I'd like column A sorted by Alphabetical order automatically.
2) Is it possible to have the sheet either reset after each use, or not save live changes? Like if someone accesses it and filters it, then closes it. If someone else accesses it, it'll have the filter applied. I'd much rather the sheet be the same each time it's opened so no-one misses anything. I was hoping there was maybe a permissions setting where people can look and filter, but have no "write" access to where it's saved so that their changes aren't saved live.?
Massively appreciate anyone who can help as I'm properly stuck on these aspects at the moment.
Kind Regards,
Cameron.
Bookmarks