Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a column with 6 different entries, contract 1, contract 2, contract 3, contract 4, contract 5, contract 6. How do you do a formula in a custom column to say if column says contract 1,2 or 3 put new contract in the custom column and if column says contract 4,5,6 put old contract,
many thanks
Solved! Go to Solution.
Case sensitive as follows
= if [column] = "contract 1" or [column] = "contract 2" or [column] = "contract 3" then "new" else "old"
Thanks Matt, I have followed that but get the below error
You seem to be missing a " after (Mantra)
Brilliant thanks for your help
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |