Hello People, I want to use showif based on v...

Hello People, I want to use showif based on values in more than 1 column, possible? So in plain englist it’ll be like “showif the value in column a is x and in column b is y”

0 5 365
5 REPLIES 5

@Mayank_G

Considering your columns are Text type:

AND([ColumnA]=“x”,[ColumnB]=“y”)

@Mayank_G

Considering your columns are Number type:

AND([ColumnA]=x,[ColumnB]=y)

@Mayank_G

Considering your columns are Text based ENUMLIST

AND(CONTAINS([_THISROW].[Column A],“x”),CONTAINS([_THISROW].[ColumnB],“y”))

@Levent_KULACOGLU thank you sir!

@Mayank_G you’re very welcome

Top Labels in this Space