Hi All,
Just have a query regarding Smartsheet forms. I am currently setting up a form to track consumables for a project. The project may have up to 20/ 30 different consumables associated with it.
Is it possible to use a multi-select dropdown for the user to enter these consumables which in turn will enter the required consumables on a new line?
Getting the user to submit 25-30 different forms isn't feasible - while creating 25-30 separate columns to track each consumable and then try to pivot that data within Smartsheet also won't work.
Any ideas/ workarounds would be greatly appreciated.