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

(Mayank G) #1

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”

(Levent KULAÇOĞLU) #2

@Mayank_G

Considering your columns are Text type:

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

(Levent KULAÇOĞLU) #3

@Mayank_G

Considering your columns are Number type:

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

(Levent KULAÇOĞLU) #4

@Mayank_G

Considering your columns are Text based ENUMLIST

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

(Mayank G) #5

@Levent_KULACOGLU thank you sir!

(Levent KULAÇOĞLU) #6

@Mayank_G you’re very welcome