Check box formula

jamies

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! 

Andrée Starå

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

J. Craig Williams

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 semi-colon. 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.