1

There's a Google form that's linked with a Google sheet: whenever a response is posted to the forme, a new line is added to the sheet (here's a quick tutorial just in case).

Is it possible to have this newly added line to include some formulas?

As an example, say the web form asks for

Name 
Date of birth

Then I'd like the output Google sheet to look like

Name          |  Date of Birth  |  Age
<from form>     <from form>        =TODAY() - B2  

While by default, the third column is created with no value

  • There's a workaround : create another spreadsheet with data linking from the lone linked with the forms. That second sheet will not autosize when rows are added though – PPC Jun 1 at 21:04
1

You will need an array formula for that purpose:

=ARRAYFORMULA(IF(LEN(B2:B), TODAY()-B2:B, ))

or in the first row:

={"header"; ARRAYFORMULA(IF(LEN(B2:B), TODAY()-B2:B, ))}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.