Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Adding a numeric value to a cell with a checked box
I'm having a hard time and maybe it's because it's obviously not even possible?
I'm wondering if a checked box can also equal a numeric value without adding additional columns. Possible?
(Photo referenced below) If so, GOAL: Ex if checkbox is checked in this cell in Column BIGKY then that cell has a value that equals 50. Then in Column LILKY each cell when checked = 100. SO if in row2 Column BIGKY cell is checked and LILKY is checked I could do a sum formal in a Column Total to add both checked boxes' value Ex Column BIGKY checkbox value is 50 + Column LILKY checkbox value is 100 = 150 and would be written in column Total
.. I may be crazy.