Modified on Thu, 25 Apr at 5:17 PM


The IF/THEN functionality in Gigasheet is a logical function that allows you to test a condition and perform a specific action based on the result. The function checks whether a condition is true or false and then returns a value or performs an action based on that result.

How to use If/Then 

Step 1: Go to Insert and select "If Then" from the dropdown

Step 2: Input the necessary fields as shown below: 

New Column Name: The new column header/name you would like generated based on the Condition Groups

Condition Group:

  • Column: Select the original column the "if/then" functionality will be based on
  • Operator: Select the operator based on Column. 
  • Value: Select the specific value the "then" statement will be based on
  • Then: The original value that will be replaced in the new column 
  • Else: The new value that will be generated in the new column in place of the "THEN" value

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article