Set cell formula action

The Set cell formula action of the Google Sheets package enables you to set a formula in the active cell or a specific cell in a Google sheet.

Settings

  • In the Actions palette, double-click or drag the Set cell formula action from the Google Sheets package.
  • Use the Session name field to enter the name of the session used to open the workbook with the Open spreadsheet action.
  • Use the Cell options field to select one of the following options to specify the cell in which you want to set the formula:
    • Active cell: cell that is currently active.
    • Specific cell: specify the address of the cell in the Cell name field.

      (Optional) Click Insert a value icon to select an existing variable.

    • Multiple cells: specify the range of the cells in the Cell range field.

      (Optional) Click Insert a value icon to select an existing variable.

  • Use the Cell formula field to enter a formula.

    Ensure that you do not use "=".