How to fix OR formula in Disable IF for a button

Start Here! Coda Basics
1

I have been struggling for a while to fix error in the formula of Disable IF for a button.
I would like to disable button when row value of column 5 (select list) is either AA or BB
Disable IF: thisROW.Column_5=“AA” OR (“BB”)

Thx

Herve

2

@Herve_Soursou

Try one of these:

thisRow.Column5 = "AA" OR thisRow.Column5 = "BB"

OR(thisRow.Column5 = "AA", thisRow.Column5 = "BB")

3 Likes
3

Hi @Herve_Soursou
and welcome to Coda Community :handshake:

As @Ander correctly suggested, they both work.

If you have multiple values and need a more concise way to express it, you can also go with:
thisRow.Column 5.In("AA","BB")

Have a look at the Formula Reference and you’ll find a good deal of examples and inspiration.
Cheers!

3 Likes
4

thx @Ander and @Federico_Stefanato all your formulas work :handshake: :blush: