Some forms not populating data in rows after submission
I am hoping for some help with this. I have a sheet that has a lot of automations and sheet sharing. Data feeds are primarily based on the submission of a form, which is critical to capture and can come from anyone with access to the link.
I have had 8 form submissions, 4 have come in blank, which is odd because I have required fields on the form. In the audit, I see where the successful ones show something like (partial caption):
Row 4: "Field" Program Status: (blank) to: New Submission First Name: (blank) to: Sam Last Name: (blank) to: Smith EID: (blank) to: 555555 Duplicate Check: (blank) to: false City Lives In: (blank) to: Miami State Lives In: (blank) to: FL
For the ones that don't come through, I see this in the audit:
Row 3: "Field" Program Status: (blank) to: Not Active EID: (blank) to: (blank) Duplicate Check: (blank) to: false Current Location #: (blank) to: (blank)
Notice how the fields for name, etc. are not in the 2nd example. On the form I have a couple of fields that are prepopulated and hidden, so those came through, but everything else in the row was blank.
It is critical that no form submissions are missed, so I need to find the root. I have checked all the way to the bottom of the sheet. I have checked cell history of those rows (they have none with exception of the pre-filled), I have 1 automation that moves rows (not the issue bc I have the rows just no data) and ran through the audit with a fine-tooth comb. I am not a Smartsheet pro, but I get by enough and this is blowing my mind.
Also, is there any feasible way to find the information that was submitted in the form? I need to find out who that was among thousands of possibilities.
Any advice is very appreciated!