Putting a formula in with a form submission.

We are trying to set up a form where you enter scores base on criteria that populates a form. Based on that data each new line of data from the form needs to have the average score of those 6 criterias. However we can't pre-fill each row with the Average formula we want as the form always drops the data in the row below that. The row has to be completely empty for it to put the data in it seems.

Is there a way to have the form data populate a row with a formula already in it, or alternatively the form pre-fill the average formula in each time.

Thanks!

Find more posts tagged with

Forms

Formulas

Comments

Mike Wilday

Make sure you have the formula pre-filled into at least 2 rows above the last row. Then delete ALL of the empty rows. And Smartsheet will auto-fill in the formula for you.

Formulas will autofill when they are in the rows either two-rows above or two rows below the new row, at the same level of hierarchy.

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting

If you're starting off fresh... add a couple of dummy rows and then hide them. But make sure you delete every blank row below the rows with your formula. (Smartsheet always adds blank rows back in but those are for aesthetics. New form entries will go acquire the formulas.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.