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.
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution.
I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have to go in and update the formula each time a cell changes to meet the formatting requirement. Here is a visual that I hope will help explain what I am trying to do. I'm guessing there might be some sort of imbedded formatting involving a variation of an IF statement, but I'm just not sure.
I want B1 to add up all numbers in the column, but only once the shading has turned to green.
So currently B1 would report "5" (without quotes), and if I checked the box in A8, causing B8 to turn green, B1 would automatically change to "6"
Collumn B has conditional formatting to turn green when I check a box in column A