Show if column

Dear All
Please help me with this
I want to add to a column Show_If column 1 contains (Cleaning Inspection) or column 2 contains (Cleaning Inspection)

Thanks in advance

0 5 159
5 REPLIES 5

Hi @Ramy_Moussa
What did you try?

@Lynn I tried this
CONTAINS([Rating 1], โ€œCleaning Inspectionโ€), CONTAINS([Rating 2], โ€œCleaning Inspectionโ€)
but it only works with the first column only

Put OR() statement in your formula

@June_Corpuz i tried it too but not working

What did you try? Please post a screenshot of the full expression.

Top Labels in this Space