Sign in to join the conversation:
If you save a workspace as new and rename it, would you also have to rename the sheets that are in the workspace?
Just wondering if they were the same would that mess up any formulas?
Thanks,
Cheryl
Hi Cheryl,
Fortunately, no you don't need to rename the sheets it will continue to work.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Cheryl,
In addition to what Andree mentioned, if you do need to rename sheets, reports, etc. it will not break any formulas or links.
I have a workspace that I use as a template for other programs and I need to change the names of the sheets to reflect the new program name for the end users.
To add to Marks clarification.
I would recommend that you have a naming convention because it will make it a lot easier to find what you need and it will also make it easier to set up reports, dashboards, cell-linking and more.
Andrée
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriate…
