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



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
    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.


    Forever forwards Backwards never.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!