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.