Set cell formula action
- Updated: 2023/06/21
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 "=".