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!