Sign in to join the conversation:
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
Yes, unfortunately, it does.
a way to automate adding columns across multiple sheets is through the API, if you are comfortable writing code - http://smartsheet-platform.github.io/api-docs/?python#add-columns
Weighing up the practical considerations, if the extra column does not have formulas (i.e. they are just manually entered values), is not being referenced via cell links (that you have to set up for each sheet) and we're only talking about 25 sheets, then you're probably better off just creating the columns manually and moving on.
An easier way to add a single or multiple columns is to create a new sheet with the new column(s). Then you can copy the blank row to the desired sheets. If the target sheet does not already contain the new column(s) they will be added.
Advantages: the column data type is maintained. Saves lots of time if you are adding multiple columns. Doesn't affect the data since you are adding a blank row.
Disadvantages: formulas can't be copied into a sheet. There could be a better way but I haven't found it yet.
Hope this helps!
Hi Mike,
Great, advise! I also do that, and I also put a unique character before the formula so it's just text and after I copy the row to another sheet I search and replace that character and that will activate the formulas in the new sheet.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
