Sign in to join the conversation:
Is there a way to automatically exclude sheets from reports if the sheet name contains a certain string?
Not directly. You could use a hidden column (we can call it [Sheet] for this example). You would then enter your sheet name in this column for all rows. Do this on all sheets.
Then in your report builder, you would include this new column in your What? criteria and say to exclude rows that contain "whatever string you want to exclude".
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
We had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
