Yes / No Return for a 1, 0, or null

jem102166
Participant II

I have a column that has a 1, 0 or is null. I want to display YES for 1 and NO for 0 or null. Please let me know if anyone has any ideas. Thanks!

Solved Solved
0 3 448
1 ACCEPTED SOLUTION

Maybe this

SWITCH([Column Name], 1, โ€œYesโ€, 0, โ€œNoโ€, โ€œNoโ€)

View solution in original post

3 REPLIES 3

Maybe this

SWITCH([Column Name], 1, โ€œYesโ€, 0, โ€œNoโ€, โ€œNoโ€)

You will need to use that formula in another column. If your Consignment column has 1,0 or null as values populated, please use the formula in another column to get the desired result and display that column in views.

jem102166
Participant II

Thanks! It had been a while since i had been in to edit and as soon as you said it bang virtual columnโ€ฆ

Top Labels in this Space