Auto Populate Form Fields

Haley W

I have a form that managers will fill out stating who participated in a project and what percent of the project they completed. I have a column that auto calculates the total percent (with conditional formatting) to help with the final review of the information. I would like the total percent field to show on the form and auto calculate as the form is filled out. Is there a setting or formula that will allow this?

Andrée Starå

Hi Haley,

Unfortunately, there isn't a way to do that natively in Smartsheet. It might be possible with a third party tool like Google Form or similar.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting