Check Box Selected / Not Selected = YES or No


High Smartsheets Community,

Question. Is there a formula for if a check box in a column is selected that it would return an answer of "yes" in another column and vice versa, if a check box is not selected it would return an answer of "no." I know I can do a drop down, but there are some other factors that require me to have a check box column.

Thanks, and I hope you all have a great weekend!

Best Answer

  • ker9
    ker9 ✭✭✭✭✭✭
    Answer ✓

    Hi @Anthony DAmbrosio

    Checkboxes use a 1 for True (yes) and a 0 for False (no).

    Formula: =IF(Chkbx@row = 1, "Yes", "No")

    Change "Chkbx" to your column name. If your column name is more than one word it will need to be wrapped in brackets like this: [Column Name]

    You can make this a column formula so that it occurs on every row.

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!