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

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…