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

Kelly Hogan
edited 12/09/19 in Archived 2016 Posts

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. ;) 

Screen Shot 2016-11-30 at 6.44.35 PM.png



This discussion has been closed.