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'))
Last modified 1yr ago