Using advanced formulas in your Google Sheets template

Follow

Comments

8 comments

  • Avatar
    SensorsONE

    You mention to add a new sheet to the responses spreadsheet for the calculations, but shouldn't it be the invoice template where you add the calculations?

  • Avatar
    Form Publisher Team (Edited )

    Hi SensorsONE,

    You can either do your calculations on a separate sheet as explained from points 1 to 3, or calculate directly on the invoice template (see point 4.). Both will work! We have added this information on the article, thanks for your comment.

  • Avatar
    Randy Baril

    Is there a way to perform simple date calculations in a Google Doc?

  • Avatar
    Form Publisher Team

    Hi Randy Baril,

    Unfortunately, we did not find anyway to perform calculations in a Google Doc yet. We will continue to look for a solution and we'll keep you updated. 

    In the meantime let us know if you manage to pull this up!

  • Avatar
    Seiji Ohara

    Is there a way to have the calculations done outside Google Docs and then send the results back to Form-Publisher through some web response before the PDF is created?

    What we are trying to to do programmatically: automate formula creation, vlookup contents, personalized messages/results/conclusions for aggregated/anonymous data.

  • Avatar
    Form Publisher Team

    Hi,

    There is no way to get out of the Google Drive environment so (slide/sheet/doc) bfore the pdf creation, and the only type of file that allows formulas is Google Spreadsheet.

  • Avatar
    Mr Nigel S Haslam

    I need to combine Form Publisher's advanced formulas on a second sheet with Yet Another Mail Merge's ability to send an HTML email from my Google drafts folder.

    I can pull question data into the email template using the <<Markers>> but how to I access the VALUE data in a formula populated cell in my second 'operations' sheet, as shown in the Hotel Reservation tutorial?
    Thanks in advance

     

  • Avatar
    Form Publisher Team

    Hi,

    You can only pull this data in another sheet of your template, not elsewhere.

Please sign in to leave a comment.

Powered by Zendesk