Conditions
When should the automation be executed
This is an optional step that lets you set up a set of conditions when the automation is executed. You can use these properties to customize your rule as it is applied to your data, like when range A1 is equal to x.
Logic Sheet automation condition
Once you have clicked the "Add a condition button," you will see an option that lets you choose "When all/any of the conditions are/is met." If you choose "all," the automation will only run if all of the conditions you have set are met. If you choose "any," the automation will run if any of the conditions you have set are met.
Currently, we only support range conditions. Row conditions and column conditions are on the pipeline.

Range condition

When range

In this field, you can type in the range reference of the cell you want to compare. The range reference must be in the A1 syntax. In the following screenshot, the cell highlighted in green can be referred to as "B3" as it is in the 3rd row of column B. You can also find this reference in the name box at the top left of your worksheet.
The cell highlighted in green can be referred to as "B3" as it is in the 3rd row of column B.

Merge tag available

You can use merge tags in the input field only when you have chosen the "spreadsheet is edited" trigger.
You can use the following merge tags in the Value field here. See how merge tags work.
  • {{edited range}}: The range notation of the cell being edited. For example, A1 will be returned if the edited range is A1.

Condition

The Condition dropdown menu here refers to the operator of the comparison you want to make. Here are all the operators you can choose:
  • is equal to
  • is not equal to
  • is greater than
  • is greater than or equal to
  • is less than
  • is less than or equal to
  • contains
  • does not contain
  • is empty
  • is not empty

Value

The value to compare to. The following configuration will let the automation run only when cell A10 is less than 100.
The automation will run only when cell A10 is less than 100.

Merge tag available

You can use the following merge tags in the Value field here. See how merge tags work.
  • {{range A1}}: The value of cell A1, or other cells of your choice.
  • {{old value}}: The value of the cell prior to editing.
  • {{new value}}: The new value of the cell after being edited.
  • {{editor}}: The email address of the user who made the edit.
  • {{edited range}}: The notation (string) of the cell being edited.
You can add or remove conditions by clicking on the "Add a condition" button or the close sign of each condition.
Copy link