Forms data populating worksheet

I have created a form and I have it set to populate at the top of the worksheet. I have a summary section at the top of the worksheet so I can show all the in progress, completed, etc. for all the contracts. I need the form data to start below that summary level on row 7. How do I set this up to happen. When I set it to load at the bottom, it puts all the data way down on the sheet.

Find more posts tagged with

Forms

Comments

Andrée Starå

Hi,

Unfortunately, it's not possible to choose where the submissions should start except on the top or the bottom of the sheet. You could add them on the top and then move them down to after the summary.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

sean59916

Adding to Andrée's response, you could also, move your summary to another sheet and reference the data sheet, set the form data to submit to the top.

Paul Newcome

What do you mean by it puts it way down on the sheet? If you are referring to having a bunch of blank rows between your summary and first form entry, it could be that those empty rows just need to be deleted.

jharper56136

Thanks! I will give that a try 1st. I am not sure why it is putting them at the bottom.

jharper56136

Thanks so much! I will give that a try.

jharper56136

Thanks Andree! I will try a few things and see if it works.

Andrée Starå

Happy to help!

Best,

Amdrée

Paul Newcome

Happy to help.

Regarding form entries, there are only two different types of rows, and forms can only populate one of those types.

There are blank rows. These HAD data in them, but the data has since been deleted. Even though there is no data in them, they are still considered as "used" and a form cannot populate them.

And there are unused rows. These rows have NEVER had any data in them. These are the types of rows that form entries can populate.

If you had test data or any other kind of data in a row and have the forms set to populate at the bottom of the sheet, the new entries will go to the first UNUSED row. That means all of those blank rows need to be deleted to move the first available unused row to the top of the sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…