Hi everyone, I am looking for help regarding how Smartsheet forms populate rows. We are currently using Smartsheet to complete our annual employee evaluations, which consist of three sections, one for the employee, and two manager sections (completed by two different people). We initially had the employee fill out a Smartsheet form for their section, and triggered a workflow that would send 'Update Forms' for the two final sections...however Update Forms are only based off of column headings (as far as I know), which does not work with the length of our questions, and does not allow for customization (such as adding headings, instructions, etc.).
Now, we decided to have three seperate Smartsheet forms (one for each section), where we manually email the links to the relevant individuals and have them fill out the forms. This is where the issue arises...Smartsheet only allows one form per row, so when an evaluation is complete, we have to manually copy two of the rows up so all the information is in one row (We export the rows to an official document using Document Generator which is why having one row per evaluation is important). This can be problematic as everyone begins there evaluations at the same time but don't all submit them at the same time, so 10 employees could submit an entry before any of the other two sections are submitted. This makes it all the more time consuming to sort through and copy and paste rows etc.... Is there any way to prevent these 'multiple row' entries, or way to use the update form that I am not aware of?...Any suggestions?
Thank you in advance!!
