"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!
Answers

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!