Creating forms with common and uncommon columns
I have around 10 forms to create, call them PC01, PC02, PC03, etc. All of the content bones I need for the forms are in a single sheet. There's a column that identifies to which form each question belongs, it's a multi-select column and includes the option of "All" (questions that are common to all forms).
I then have filters to show/hide for each form, e.g. a filter for all rows that pertain to PC01. I'm then copying all the questions in the filtered questions column and pasting them into Sublime text so I can comma-delimit them and save a .csv file to import back into Smartsheet so the questions are in column form, ready for form-making. Of course then I have to go thru and assign field types for each.
So TLDR, there are a lot of steps, a LOT of copying/pasting. It would be REALLY helpful to be able to copy COLUMNS from one form to another. While there is no obvious way to do this, is there a workaround of some sort??
Help Article Resources
Check out the Formula Handbook template!