Form submissions not showing on sheet

John Foster

I have started to use a form on a sheet that has not been used for some time, but the submissions are not being added to the sheet. I have waited more than 15 minutes, has anyone else had any issues with this?

Andrée Starå

Hi @John Foster

Have a look at the bottom of the sheet and also make sure that you don’t have any filters active.

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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

John Foster

https://community.smartsheet.com/discussion/comment/261930#Comment_261930

Hi,

I have refreshed the page, removed all filters and checked both the top and bottom row, despite the form being set to add at the bottom. I have submitted from an existing and a new form, both of which do not work, I have switched on sending of updates to the user and selected to do so when adding an entry. This still does not work.

Thanks,

John

Andrée Starå

@John Foster

Happy to help!

Strange!

Can you check the Activity Log and see if there are any clues there?

Do you see the submission there?

John Foster

@Andrée Starå

Thank you, I have checked the activity log, but have not been able

Andrée Starå

@John Foster

Ok.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

John Foster

@Andrée Starå

I have shared the sheet with you, many thanks for your assistance with this.

John Foster

@Andrée Starå

Many thanks for your help with this, sorry I was being silly and not looking down far enough. I did not realise I had blank rows in the sheet.

Andrée Starå

@John Foster

You're more than welcome!

Easy to miss!

Glad we got it working!

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

Jake Gustafson

I ran into this same problem yesterday/today. I am helping a colleague with a sheet/form he created, but when I added my new entry via the form, I wasn't seeing it. It was at the way bottom of the sheet, after like 50 blank/empty rows. So I'm guessing the owner of the sheet clicked in those rows or did something where the form input thought there were valid records. Glad it wasn't something more major, I was thinking we may have to recreate the form, which would have been less than ideal.

Murph

I am having this problem today. I checked the activity log and it shows that a row was inserted, but it does not show on the sheet. I also checked to make sure I don't have any filters on. I have submitted several test entries using the form and none of them appear on the sheet, but the activity log shows they were inserted.

Never Mind - I found the entries - They were WAY WAY down on the sheet after dozens of blank lines

Mike Jungers

Has anyone come across a way to prevent the form submissions from populating way down the sheet when using "Add to bottom"?

I always assume operator error and find a fix but this one has me stymied.

Mike

Andrée Starå

https://community.smartsheet.com/discussion/comment/390683#Comment_390683

Hi,

I hope you're well and safe!

If all the activated rows except for the last that is populated are deleted, it should add to the next available row.

Doesn't that work?

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!

Mike Jungers

Thank you Andree for the help. It turns out I had a column set to conditionally format zeros to white text, which I use to declutter dense sheets sometimes. Once I fully cleared the rows the form populated properly.

User error strikes again.

Best,

Mike

Andrée Starå

https://community.smartsheet.com/discussion/comment/390810#Comment_390810

Excellent! Easy to miss!

Happy to help!

✅Remember! 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!