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 369
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