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

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!

Maybe this

SWITCH([Column Name], 1, “Yes”, 0, “No”, “No”)

3 Likes

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.

1 Like

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

2 Likes