Another "form submissions not adding to worksheet" issue

I hope you're well and safe!

Strange! It seems that they are stuck somehow.

If you haven't already, I recommend submitting a support ticket through the new Smartsheet Support Portal.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

A few other things to check:

Any move row workflows?
Conditional formatting, or manual formatting that makes it appear "invisible"? (e.g. white text). Try using Find in the sheet to see if there's hidden content.
Scroll to the right in case they're submitting in new columns that were created from a copy or move row workflow?

Let us know what you find out!

Cheers,

Genevieve

There are two workflows set up to Move a Row and Copy a Row (both to unknown destinations, worksheets I don't recognize).

It seems likely this is behind the issue, but I'm not sure how to fix it. I believe these were part of some logging and reports setup that's no longer used, but it was built by a previous admin. Would it break anything to just deactivate those workflows? And more to the point, would that restore the missing entries on the worksheet? That's the main goal, to recover those submitted entries and make them show up on the sheet.

That looks like that's it!

It seems like this specific sheet is being used simply as the intake sheet, then moving rows over to the working location.

Can you see where the Copy Row workflow is pointing to? Based on the title, "...to Operational Workspace", I'm guessing that the sheet where these rows are originally copied to is the sheet where they're being tracked/actioned etc.

The Archive Request workflow then moves them out of the Intake Sheet so that your intake sheet never fills up. (A full sheet that has reached cell limits will not be able to receive new form submissions).

I would suggest following the trail of the rows to see where they end up before deactivating current workflows.

I hope that helps!

Genevieve

OK, I've tracked down the copy and move pointers and confirmed that the destination sheets still exist. (We don't use them for anything, but they exist.) So that seems to be valid. Now I'm stumped again.

Do you mean that the new submissions are not showing up in the desination sheets?

A new submission has appeared since I confirmed the links, but the missing ones are still missing. Are we out of luck for retrieving those?

Have you completed the same checks on these destination sheets?

Filters
Scrolling
Workflows
Activity Log
Colour formatting