Check Box Selected / Not Selected = YES or No

Options

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 ✓
    Options

    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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!