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

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.

Answers

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

    Cheers.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!