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


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"?

Best Answer

  • Heath Hilton
    Heath Hilton ✭✭
    Answer ✓

    Vinton Douglas,

    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!