Portant Docs
Launch PortantInstall App in Hubspot ↗︎
Portant Docs
Portant Docs
  • 👋Welcome
  • 🟢Product Updates
  • 🌱Getting Started
    • How to Sign up
      • Sign-up without a Google account
    • Quickstart
    • Ask for Help
      • Support Tickets
      • Support Codes
      • Screenshots
      • Developer Console
      • 400 Error
      • Resolve: API developer key is invalid error
      • How to request a transfer of your Portant account
    • Templates
    • Delete Multiple Workflows at Once
  • How to Set Up Your Account's Global Formatting Settings
  • Change Language Settings
  • 💫Personalise Documents
    • Adding Hyperlinks
    • Adding Images
    • Use custom tag names
    • Tag Formulas
      • Global tags
      • Tag Formulas
      • Tag IF Statements
    • Invalid Tags
    • Portant AI Content
    • Dynamic Google Sheets Charts
    • Tag Checker
    • Add online payment links
    • Add Stripe Payment Links to Your eSign Portal
  • 🌐Sources
    • Google Forms
      • Add formula fields to your Google Form workflow
      • {{tags}} for Google Forms
    • Google Sheets
      • Google Sheets Auto-create
      • How to source data from multiple Sheets
      • Saving Document Links to your Sheet
      • Data Grouping
    • HubSpot
      • How to install the Portant App in HubSpot
        • How to Add Portant App Cards to HubSpot
      • Create a Document in HubSpot
      • How to manage and select HubSpot Properties
        • Full list of available HubSpot Properties
      • Trigger HubSpot Workflows from Portant
      • Add a Portant Action to a HubSpot Workflow
      • How to view created documents in HubSpot
      • Add multiple line items into a single document
      • Add Deal Tags using Portant document statuses
      • Portant eSignatures + HubSpot
      • Review documents using the Review Block in HubSpot
    • Zapier
    • Glide
    • Webhooks
      • Webhook Data Grouping
    • Xero
    • Copper
      • Installing the Copper integration
      • Create your first Copper workflow
      • Generating your first document from Copper
    • Typeform
    • Tally
  • 💡Use Cases
    • eSignatures Requests
    • Incident Report
    • Quarterly Business Reviews
    • Invoices
    • Convert Form Responses to PDFs
  • ✒️eSignatures
    • Getting Started
    • Request Signatures (without a source)
    • Request Multiple Signatures
    • Customise Signature Request Email
    • Create Preview Links for Signature Requests
    • Resend signature requests
    • Cancel Signature
    • Add Audit to eSignatures
    • Request Info On Signing
    • eSigning Laws & Compliance
      • United States: E-SIGN Act and UETA ✅
      • Canada: PIPEDA and Electronic Transactions Act ✅
      • EU: eIDAS Regulation for Electronic Signatures ✅
      • UK: eIDAS Regulation and Electronic Communications Act 2000 ✅
      • Australia: Electronic Transactions Act (ETA) ✅
      • New Zealand: Electronic Transactions Act (ETA) 2002 ✅
      • Israel: Electronic Signature Law 2001
  • ⚡Automation
    • Workflow Filters
    • Re-run an automation
    • Review Block
    • Converting docs to different file types
      • Microsoft Word (.docx)
      • Microsoft Powerpoint
      • Create PDF outputs
      • Save an output as a Microsoft Excel file (.xlsx)
  • ✉️Emails
    • Share a Doc via Email
    • Email Tracking
    • Send from aliases
    • Send Outlook Emails
    • Customize Your Email Content with HTML Editing
  • 📄Outputs
    • Customize Output File names
    • Auto-filing Output Files
    • Changing Output Folder
    • Search and filter your outputs
  • Deleting Outputs in Portant
  • 🎁Portant Add-ons
    • Data Merge
      • How to set-up a Google Sheets source
        • Data Merge Settings for Google Sheets sources
        • Automatically create documents
      • How to set-up a Google Forms source
        • Data Merge Settings for Google Forms
        • Automatically create documents
        • Edit Response and Pre-filled Response Links
      • Inserting Images
      • Advanced Settings
        • Editing tag names
        • Timezone, date and time format settings
        • Editing the Output Folder
        • Conditional logic for emails
        • Conditional Logic for Data Merges
        • Data Grouping in Portant Data Merge
    • Document Merge - Trello Power-up
  • 👥Teams
    • Creating Your Team
    • Sharing Workflows
    • Creating Folders in the Workflows Tab
    • Managing team permissions
    • Whitelabeling eSign Portal
  • 💳Billing
    • Update Billing
  • Developer
    • Build with Portant
Powered by GitBook
On this page

Was this helpful?

  1. Sources
  2. Google Forms

Add formula fields to your Google Form workflow

How to use and add additional fields to a Google Form workflow

PreviousGoogle FormsNext{{tags}} for Google Forms

Last updated 5 months ago

Was this helpful?

Sometimes you might need to calculate a value conditionally insert other content based on form answers. e.g. If the users selects an office location, add the address, phone number and email address for the location WITHOUT having to ask the user to select these details as well.

The majority of the time, you can achieve this by using or

But if these don't work, this guide will show you how to set up a Portant Workflow based on a Google Forms Response Sheet and add formula to it.

In this article, you’ll learn how to:

  1. Set up a data merge for a Google Forms Response Sheet

  2. Add formula to the sheet

Set up a data merge for the Google Forms Response Sheet

To set up a data merge that uses a Google Form response sheet, you need to switch it on from your Google Form. First, open up your Google Form, then click the 'Responses' tab in the centre of the page. Then click the Google Form icon in the top right corner of the page 'Create Spreadsheet'.

After you have clicked this icon, you can select if you'd like to make a new spreadsheet or add it as a tab in an existing spreadsheet. This means any time you receive a response for your form, the data will be inserted into this Google Sheet.

Then create a new workflow in Portant that uses the Google Sheet you just created as the source.

When you turn on Auto-create for this workflow, Portant will check the spreadsheet every 2 minutes and create documents any time it finds new data.

Add formula to the sheet

Ok cool. So what we have made so far is just a slightly more complicated version of a Google Forms source workflow. However, now I'm going to show you how to make it more powerful by adding additional fields which can contain formula, or conditional content based on answers in the form.

There are two ways to do this:

  1. Array Formula in row 2 of the Response Sheet

  2. Array Formula in a New Tab of the Spreadsheet

Array Formula in row 2 of the Response Sheet

To add an array formula to a Google Sheet, which is especially useful for applying a formula to an entire column of data, start by clicking on the cell in Row 2 after your last column of data. Type the equals sign '=', followed by 'ARRAYFORMULA(', and then input your desired formula. Close the parenthesis after your formula is complete. Remember that the array formula will automatically expand and fill the cells in the column or row you specify. Here's a simplified example:

=ARRAYFORMULA(A2:A*2)

This formula will double the value of every cell in the range A2 through the last row in column A.

You can also add an if statement to add content dependant on an answer with the Form response. For example this formula would add "This value is Yes" any time the form response in column A was "Yes" (and it would be blank if it wasn't yes):

=ARRAYFORMULA(IF(A2:A="Yes", "This value is Yes",""))

Make sure to hit 'Enter' to apply the array formula to the desired range or column.

Then whenever a new response is submitted to the form and added to the bottom of the sheet the array formula will be calculated and added to the response's row of data

Array formula in a new Tab of the spreadsheet.

This is a good option if you aren't as familiar with Array Formula or if you have a formula that doesn't work with Arrays.

The first thing we need to do is to copy the response sheet data into a new tab in your spreadsheet.

We recommend using an array formula to do this: =ARRAYFORMULA(Sheet1!A:X) with A being the first column of your response and X being the last column of your responses

Then you can add additional formula to the columns after the last column of data in your spreadsheet.

How add formulae to sheets (which don't display an error when blank)

When you copy a formula onto multiple rows the blank rows (after the last response) can sometimes display an error or a zero, which will interfere with Portant's auto-create. To avoid these errors you need to use a formula to display BLANK instead of a zero or error.

To avoid errors you can use the IFERROR formula: =IFERROR("no error", "error") Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent e.g. =IFERROR(A2*100, "")

To avoid zeros you can use the IF formula: =IF(logical_expression, value_if_true, value_if_false) Returns one value if a logical expression is 'TRUE' and another if it is 'FALSE' e.g. =IF(A1="","",A1*100))

For a Full-Proof way of preventing against Errors or "0" values please combine the formula like this: =IFERROR((IF(A1="","",A1*100)),"")

Feedback and feature suggestions

We created Portant in 2021, and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback, please feel free to send us an email at

🌐
contact@portant.co
Tag Formula
Tag IF Statements