Check box formula
Can anyone help with a formula so that if the box is checked, it will automatically do the calculation [sample size]1*1.07?
Thank you!
Comments

Hi Jamie,
Formula placed in "Total" column
=IF(IF1 = 1; [Sample Size]1 * 1,07)
I hope this helps you!
Best,
Andrée Starå  Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Jamie,
Andrée's answer for newbies:
=IF(IF1 = 1; [Sample Size]1 * 1,07)
This is looking at a column named [IF] on row 1, which is assumed to the be same row as the rest of the formula. [IF] can be either a Checkbox type column or a Text/Number type column, because a checked box has a value of 1.
=IF(IF1 = 1; [Sample Size]1 * 1,07)
Both [Same Size] and [sample size] will work because Smartsheet's column names are case insensitive in formulas. This is likely due to wanting to avoid two columns with names different only be case (which has a VERY small use case and is easily worked around)
=IF(IF1 = 1; [Sample Size]1 * 1,07)
Andrée is European, so ...
The formula is using a semicolon. US (and a few other countries) user's will use a comma there.
The number in Andrée's answer has a comma in it. This is NOT 1 comma 07 but the same as 1 point 07 for US (and a few other countries) users.
For more advanced users:
If all references are on the same line as the formula, try to get into the habit of using the@row reference.
=IF(IF@row = 1; [Sample Size]@row * 1,07)
This will make your formulas even easier to move around.
If the [IF] column is a Checkbox type, then this formula works as well, as the IF statement is looking for a Boolean value, which the Checkbox returns true when checked.
=IF(IF@row; [Sample Size]@row * 1,07)
Craig
ps Sorry for the length, I started with only the comma issue, and it kind of got away from me.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 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