Populate Sheet Summary with Form?

Hi there,

I'm learning Smartsheet, so apologies in advance for the basic question.

Is it possible to populate the Sheet Summary via a Form? If so, how? We have a sheet we want to create with minimal structural information in place, and the Form should be used to supply metadata we use to track and manage the sheets themselves.

I looked but didn't see an immediately clear way to do this when creating a form itself. Any advice would be appreciated!

Cheers, Ryan

Find more posts tagged with

Forms

Project Management

Comments

PPS Solutions

Hi Ryan, not possible to do via form I believe , what sort of info do you need to populate into the summary fields? We have developed an app which does this and is suited for internal use within a business. drop me a line if you need any more info. Cheers Dan

Andrée Starå

Hi Ryan,

Unfortunately, it's not possible at the moment to populate only the sheet summary, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround would be to collect the information from the form as usual but hide the columns that should populate the Sheet Summary.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

ryanhnelson

Hey Dan, thanks for the quick reply. Info would preferably include the name of the sheet, IDs for related projects within another database, and start/end dates. Of course it's possible to just enter this information quickly after creating a sheet from a template, but I thought using a form to create from a template would be an elegant way to handle the first step.

PPS Solutions

Sure fully agree. It will be interesting to see how 10,000ft Integration eventually pans out in this respect as when you create projects within that it allows you to set attributes per project which can then be used for reporting thereafter. The App we built deals with multiple templates so is designed to quickly bulk update summary fields en masse.

cheers Dan

ryanhnelson

Hey Andrée, thanks for the response! I'll give populating a sheet via form to hidden columns a try. That's another elegant way to handle that.

Thanks for sending along the Enhancement Request link; I filled that out and submitted it. I can't imagine that I'm the only one interested in being able to start a template from a form that provides the metadata (in the form of Sheet Summary) for a new project. :-)

Cheers and have a great day, Ryan

Andrée Starå

Excellent!

Happy to help!

Another way to structure a solution that I use in my client solutions is to have, for example, a so-called Intake Process sheet and then link that to a Project sheet and have the information for the specific project linked to the sheet and the Sheet Summary.

Make sense? Would that help/work?

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.