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
Hello, I am stumped again. I am looking to average data from another sheet and am getting a #Divide by Zero error, even though I believe the formula is written to ignore zeros and blanks in the data. What am I missing? =AVG(COLLECT({Indirect Project Summary -Avg Leadtime}, {Indirect Project Summary - Executive Sponsor},…
Hi all. I am working with a sheet trying to get what - I thought - would be a simple average, but the formula seems to be returning the incorrect value. I am trying to get an average of the temperature in a column if the created date (created date is the Smartsheet default column) is equal to yesterday: Which I would…
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
