Add value to a checkbox


How do I assign a value to a checkbox so that if it is checked it equals "800" and that 800 can be added to an addition formula?


  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    There are a lot of ways to do this. One way would be to add a helper column and then have a formula that says something like:

    =IF([Check Box]@row = 1, 800, 0

    But you could also put this into an equation as well.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!