Check boxes and formulas

Hello

We are using Smartsheets to build ships.. but I have an issue with the formula(S)

I want to be able to use a tick box for a formula.. 

We have many options priced and I want to use the tick box to generate option pricing. 

If the box is ticked then the price will move to the next column that is auto summed. 

If its not ticked nothing will happen. 

So 3 Columns...

1 = Price of item (Estimated Cost Total)

2= Tick box, (Selected Item)

3= Vessel Costs (Vessel Cost)

 

It seems like a simple formula, to if the tick box is selected move, copy the cost from Estimated total cost to the Vessel cost column. 

Any help would be appreciated 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try this...

    =IF([Selected Item]@row = 1, [Estimated Cost Total]@row, "")

    Put that in your Vessel Cost column. What this says is that IF the box is checked, then put in the the amount from the Estimated Cost Total column, otherwise leave blank.

  • Hello,

    Just to build off of the previous post, if you’re looking to have your Estimated Total Cost value appear in your Vessel Cost column, so long as a third column is checked, then you can place the formula provided into the Vessel Cost column.

    =IF([Check box]@row = 1, [Estimated Cost Total]@row, " ")

    When used in a formula, the IF function evaluates a logical expression and returns one value when true or another when false. In this case, the function is determining whether or not the checkbox cell is checked.

    Additionally, when working with a Checkbox column type, you can use a 1 to indicate a checked box or a 0 for an empty box.

    I also recommend checking out this article from our Help Center for more information on working with the IF function: https://help.smartsheet.com/function/if?frame=0&nav=1

    Please let me know if you’re looking for something else and I’ll be more than happy to advise further!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Just need to change [Check Box] to [Selected Item] unless your column name is "Check Box". I just assumed that what you had in parenthesis were your column names when I posted the formula.

    And to help avoid confusion... The space between the quotes at the end of the formula is user preference. Spaces vs no space works the same way when used like this.

  • Wow Perfect thanks Paul and Kelsey.. 

    I was getting the "@row" wrong on my tries. Perfect now!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!