Automatic Checkbox formula in helper column

I need some help figuring out how to get my automatic checkbox formula to work. I can't put it in the Done column b/c of conditional formatting, but I'm missing something to get it to work from a helper column.

=IF(Status@row = "Not Applicable", Done@row = 1)

Thank you!

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi Anna,

    I think you're close! Try this in your Done column:

    =IF(Status@row = "Not Applicable", 1, 0)

    If you want the Done box checked when the status is Complete, too, then you could use this:

    =IF(OR(Status@row = "Not Applicable", Status@row = "Complete"), 1, 0)

    Hope this helps!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!