Error when using switch function

[_Aleksa_]

Hello,

Thank you for your help in advance! I am getting the following error message:

[MartynRamsden · Accepted solution]

Hi @_Aleksa_ ,

You're seeing this error because RIGHT is a text function and you're comparing its result to a number.

To fix this, simply put the number 2 in double quotes (i.e. "2") or wrap the entire RIGHT function with VALUE.

Best regards,
Martyn