I am creating a tool in Smartsheet to coordinate multiple department areas around Event Planning. An Event involve selecting a location from various building options, space options in each building, date options, time options, catering options, table / furniture options, linen options for tables, floral options, Audio / Video options, Music options, etc. I am using a form (Event Request Form) to gather details on a requested event.
My challenge is that I have maxed out the 400 column limit in a single smartsheet due to the number of Event options. I am forced to now use different sheets and sheet forms for the various services offered (catering, furniture, floral, etc. ).
I am now trying to determine the best practice of using multiple sheets, with the goal of relating each row in the primary sheet (Event Location) to rows in other service sheets (catering for the event, furniture for the event, floral for the event). In short, I am creating a database of sheets with a primary key in the primary Event Location sheet.
Are there any inherent features in Smartsheet, or best practices, or thoughts on how best to use various sheets, joined by a common ID/number, so that a complete "Event" record can be created, using multiple Smartsheets? How can I get the primary sheet ID (an Auto Number column) into the other sheets, given that I am using forms in the other sheets to take service requests (Catering, Tables, Floral for example).
