Comment on page

If → Then → Else Column

Produce different values based on conditions
In this use case, we will create a custom column in the Customer table and calculate a score depending on some logical condition.
1. Simply create a new Custom field in the columns settings of the table component.
2. Now we should configure the Value for that Column using Formulas. We will use IF function to calculate Scores value, depending on the Activities number for each customer:
=IF(item.activities < 280, '50 points', IF(item.activities < 400, '70 points', '100 points'))