How to add a formula within a form that auto populates based on values filled out in other fields?

Emily Quick

I need to include a formula in a form that shows a percentage based on values that a user will input when filling out a form. I need to do this because other questions on the form will depend on the value of the formula.

For example,

My form has these two fields: Original Contract Amount & Change Order Amount

I then need a Percentage column that calculates (original contract amount/change order amount) that will populate on the form as soon as the user fills out these two fields. The user's answers to the remaining form questions will change depending on whether the percentage is above or below 5%.

After researching, I understand there is no way to include a column formula on a form, but does anyone know of a workaround? I just need any possible way to get the % reflected directly on the form. Any insight or thoughts would be appreciated!

Andrée Starå

https://community.smartsheet.com/discussion/123216/how-to-add-a-formula-within-a-form-that-auto-populates-based-on-values-filled-out-in-other-fields

Hi,

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

- Use the form, and have automation send them the submitter the answer.
- Use a sheet or report instead and have it calculated and then copied to the main sheet (simulating a form submission)

Make sense?

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!