Why do columns keep getting added automatically to my sheet? I keep deleting them, but they keep coming back at the end of my sheet.
Have you checked the activity log?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Hi @Wanda Jackson
You mention that you manually copy/paste rows across sheets... could that be creating the new columns?
"If the source and destination sheets have different column names or types, data from the row you copied will be inserted into new columns to the right of the existing columns in the destination sheet. If this occurs, scroll all the way to the right to find the data, copy it, then paste it into the desired columns."
Even if your column has the same name, if the column type is different than the source sheet the pasted data will create a new column.
If this isn't the case, I think it would be helpful to see a screen capture of the sheet before the new columns appear, after the new columns appear, and a screen capture of the activity log. But please block out any sensitive data!
@Wanda Jackson Did you double check you column TYPEs as Genevieve suggested above?
@Genevieve P Do you know if outgoing cell links could cause the extra columns to be added? I wouldn't think so, but I haven't had a chance to test yet and wasn't sure if maybe you already knew or not.
Hmm, no, outbound cell-links shouldn't create columns. If this was the cause, it would be an issue our Support team would need to look into.
Do you have an automation which Moves or Copies rows from a different location on to this sheet? If so, these rows will auto-create new columns for their content to populate if they're not already on the destination sheet. (See: Automatically Move or Copy Rows Between Sheets)
I have a disabled automation to move from this sheet to another sheet, but nothing is being moved or copied to this sheet via automation. I have copied from this sheet and moved to another one manually, so would this create the issue as well?
Hi Paul, I just checked my activity log and I've only made changes to cells, added attachments, changed column property, view sheet, cell linked to another sheet. Would Cell linking cause the issue?
Cell linking should not be adding any columns.
Do you have any move or copy row automations adding data to this sheet?
Is it the same number of columns every time?
How are the columns named?
I do not have any move/copy row automations to this sheet. It's not the same number of columns each time and they seem to be duplicate columns of what I already have on the sheet. They are just not linked to anything like my other columns and they appear at the end of my sheet.
Newly Added Event
When you say "linked"... What exactly do you mean? Are you using cell linking in the original columns and the columns that are added don't have cell links, or are you using formulas (possibly column formulas)?
I have my main sheet linked out to a couple of other sheets, no forumulas are set up for this. when the columns are automatically added, they are not linked out to any other sheet.
I did check the column type and it appears to be duplicate columns being added with the same column type that are being added back to the sheet.
At this point it may be best to troubleshoot with the Support team in a private channel - this way you can share a screen recording of the columns appearing, or full screen captures of the sheet (before and after) noting the date and time that the columns appear, and providing them with the sheet ID or URL. Please also send them a screen capture of your Activity Log.
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Can someone help me please? In the “Queue” column, I have “mapped” from “ComponentID” column a list of values (using IF function), but now I must add to the existent formula the new value “ArtStation.” This comes from a long list of alphanumeric codes. All those codes start with “asset”, the problem is that I get…
Hello - is it possible to use a group already established in SmartSheet to fill/populate a drop list for a data point? Example - we have a SS group created for 40 project managers, I would like to type the name of the group in the drop down and the 40 names populate in the drop down list without having to type all 40 names…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.