Sign in to join the conversation:
How do I save a sheet to an existing sheet so the sheet url is preserved?
Basically creating a point in time snapshot sheet each week but I want my colleges to use the same url to view the snapshot
If you want to update the data in the sheet and maintain the current link to that sheet you have to replace the data in that sheet (delete all rows and move new rows into the sheet). There are probably more sophisticated ways to update the sheet data but this is just a very simple but labor intense method
Could the snapshot be a report? This way the link is maintained and you update the report each week by adjusting the conditions in the report builder.
What type of data is being displayed in your snapshot? Is it entire rows/columns or are you just providing a summary of counts and totals?
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.
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
