Custom Column Formula

[Anonymous]

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

[MattAllington]

Case sensitive as follows

= if [column] = "contract 1" or [column] = "contract 2" or [column] = "contract 3" then "new" else "old"

[Anonymous]

Thanks Matt, I have followed that but get the below error

[MattAllington]

You seem to be missing a " after (Mantra)

[Anonymous · Accepted solution]

Brilliant thanks for your help