The If → Then → Else Column allows you to produce a new set of data for your app based on a set of conditions.
Creating a If → Then → Else Column
In the Data Editor, open the table you want to edit.
Add a new column by clicking the plus (+) symbol to the right of the table.
New columns added with the plus button will always appear on the right. If you'd like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.
Give the column a name.
For Type, search for If → Then → Else or navigate to Computed → If → Then → Else from the menu.
Set the conditions you want to use for the computation.
Configuring the If → Then → Else Column
When configuring this column, remember what each condition should be:
If: Your condition or criteria.
Then: The result you want to show if your condition is true.
Else: the result you want to show if your condition is false (or the default if you have multiple conditions).
While setting the conditions or criteria, you can use any of the column values as the data source for any part of the computation. You can also add more than one case in the event that you have multiple criteria to fulfill.