moving Just a Column to a new sheet with Automation

Alex Klingbeil

is there a Way that i can Move just a Column in a Sheet to another Sheet that will just Grab the Column. i would like it to work like the Automation that it Grabs the Row any time something is Triggered. but i would like it to just Move the 1 Cell from a Column not the Row as i don't need anything else just what got entered.

the Sheet it Draws info from is a FORM so i would like not to Bring all the Columns with just the 1 Peace of Info someone inputs off the FORM they fill out. i Tried an Index/Match but it only looks to Key words and it misses stuff.

Andrée Starå

https://community.smartsheet.com/discussion/137097/moving-just-a-column-to-a-new-sheet-with-automation

Hi,

I hope you're well and safe!

If I understand you correctly, it should work with INDEX/MATCH.

Can you elaborate/share screenshots?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me 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! I appreciate it, thanks!

Alex Klingbeil

so in our Daily Report Forms people fill out it comes up at the Far right of that Sheet as this

i would like to not Move the 40+ Columns that are attached to that. i would like to Just be any time its not -NONE- or Blank i would like to Move just the Comments Row/Cells to a new sheets. with that i can Index/Match all the Right Info so it looks like this

Right now i am Just Copy and Paste into the VE Comment Row and it will do what i need with Column Formulas but i was looking for a Way to not have to do it Manually

Thank you again to anyone looking at this to help me with this Problem

kowal

hi @Alex Klingbeil ,

As @Andrée Starå suggested instead of moving rows (which is not possible) unless you have DataMesh that can move data for you you very quickly you can use the index/match formula which works the same as moving columns (except it just fills the columns with data from the source sheet).

https://www.youtube.com/watch?v=CJJwfvIYhM0&t=8s