I have two Smartsheet forms (Part A & Part B) which are linked to my intake sheet. This is because there is no option to save the form while completing it so it made sense to split it into two. It may also be completed by different staff members, depending on the information they have available.
Both forms have the same 'Contact Information' section (Name, email address, organisation), but otherwise completely different questions.
When both forms are completed, they appear as two separate rows. I want to merge these answers into one row, however, I do not want to lose the contact information provided/date completed on both forms. It won't let me add new columns/questions with the same heading on another form, so I don't know how to do this.
Is there a way to merge rows when 'project' and 'organisation' column answers are identical, but keep the contact information for both forms (which may have different responses but will be the same column headers)?
