How to move certain columns only from one master sheet to another sheet

Nitika Bhalla

Hi

I have a master sheet - being updated regularly through forms and status changes,

How can I move some of its columns in another sheet, and use those columns as dropdown in forms to create further workflow.

Jason P

Hi @Nitika Bhalla

Short answer you cannot - The form is only pretty face of sheet columns it's built from. I have a sheet with 51 columns which represent different areas of the business: Design, Permits, Accounts and Construction. As sales teams complete the form each of those areas are alerted to take particular actions. It’s a dumb version of a Dynamic View. but it works.

khelwig

I wish we could. I also have a master sheet that's changing often - I would love an automation to copy specific columns to a new sheet for a row when a condition is met so that additional steps can be taken with that data. Maybe one day they'll update the automation feature.