Deleting Columns

ajuelsgaard

I have a sheet (I"ll call it Sheet 2) that is populated with an automation of rows copying over from another sheet (I'll call this Sheet 1). I only want to see 5 of about 30 of the columns in Sheet 2. If I delete columns on Sheet 2, when a line copies over from Sheet 1, the next day, all of the columns reappear on Sheet 2. Is there a way to only include the 5 columns that I need? I have them hidden for now but would prefer that they dont come over at all so when we export it, they arent included.

Marlana K.

@ajuelsgaard

Unfortunately not at this time. Check the feature request section and vote up if you find an enhancement request. If not it would be best to enter a request.

Why not use a report? This allows you to see only the columns you select and that report can be exported to excel. Would be happy to help if needed.

Marlana K.

@ajuelsgaard

Unfortunately not at this time. Check the feature request section and vote up if you find an enhancement request. If not it would be best to enter a request.

Why not use a report? This allows you to see only the columns you select and that report can be exported to excel. Would be happy to help if needed.

RoseCliver

https://community.smartsheet.com/discussion/114689/deleting-columns

You can adjust the automation settings or modify the copying process to exclude unnecessary columns from Sheet 1 to Sheet 2.

ajuelsgaard

How do you only select certain columns to copy/move within the automation?

Andrée Starå

Hi @ajuelsgaard

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
• Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy/move the row from that sheet to the main destination sheet.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!