# RE: Changing 0 to no and 1 to yes from a grid to a form

Hello,

I have a some columns on a grid with possible scores of 0 or 1. How can 0 be reflected on a form created from the grid as "no" and 1 be reflected as "yes"?

This one is a pretty easy formula but I added a bit extra just in case you come across a 'blank' cell or one the doesn't show a 0 or 1.

=IF([Value (0 or 1)]@row = "", "", IF([Value (0 or 1)]@row = 0, "No", IF([Value (0 or 1)]@row = 1, "Yes", "Invalid")))

Let me know if you have any trouble with this.

Hope this helps!

Heath Hilton

This one is a pretty easy formula but I added a bit extra just in case you come across a 'blank' cell or one the doesn't show a 0 or 1.

=IF([Value (0 or 1)]@row = "", "", IF([Value (0 or 1)]@row = 0, "No", IF([Value (0 or 1)]@row = 1, "Yes", "Invalid")))

Let me know if you have any trouble with this.

Hope this helps!

Heath Hilton

• Superb. Thanks much.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!