Add value to a checkbox
Options
Graham Cracker
✭✭✭✭
How do I assign a value to a checkbox so that if it is checked it equals "800" and that 800 can be added to an addition formula?
Answers
-
There are a lot of ways to do this. One way would be to add a helper column and then have a formula that says something like:
=IF([Check Box]@row = 1, 800, 0
But you could also put this into an equation as well.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!