"IF" Checkbox function question.


I have several checkboxes in my SS. I would like each check box to represent a cost to be added to a "total cost" field. (i.e. if Checkbox 1 is checked, add $2,750, If Checkbox 2 is checked, add $3,750, etc.).

Can someone tell me how to accomplish this?

Thank you!


  • kirstie858
    kirstie858 ✭✭✭✭

    There's option one, which is baking in the values of the checkboxes into the formula itself:

    Formula: =Subtotal@row + SUM(IF(Tax@row = 1, 2750), IF([S&H]@row = 1, 3750), IF([Rush Charge]@row = 1, 5000))

    You could also treat the $ amounts as variables, and create them as fields in the Sheet Summary pane.

    That formula looks like this: =Subtotal@row + SUM(IF(Tax@row = 1, Tax#), IF([S&H]@row = 1, [S&H]#), IF([Rush Charge]@row = 1, [Rush Charge]#))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!