Sign in to join the conversation:
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!
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
Jamie,
Andrée's answer for newbies:
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.
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)
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.
Hi, I am a user for a paid plan, but for some reason, smart sheets stopped letting me edit. How do i fix this so that i can edit a dashboard? Thanks!
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
