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
-
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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!