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?
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…