Automate RYG balls when a check box is ticked in one colum only out of three columns

Sally Osborne

I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns.  Can anyone help?

Carter Leffen

Hi Sally,

 

With the following formula, if one of the three checkbox's is checked, the RBG column the formula is in will turn green. Hope this helps!

 

=IF([Check1]1 = 1, "Green", IF([Check2]1 = 1, "Green", IF([Check3]1 = 1, "Green")))

 

Sincerely,

Carter Leffen

Mike Wilday

Carter's example assumes [Check1] , [Check2], and [Check3] are your column names. You will need to replace those with the names of the three columns you are checking off... and make sure the number after those names corresponds with the row you are putting the formula into.  

J. Craig Williams

Sally,

 

Warning: Carter's example will show blank for 0, 2, or 3 checked boxes.

If you change the cell manually, the formula will be gone. 

If that is what you want, that's OK.

 

If the columns are consecutive or if the columns in between do not have the number 1 or a checked checkbox, then you can also use this formula:

 

=IF(COUNTIF([Check1]23:[Check3]23, 1) = 1, "Green", "Other")

 

for row 23.

"Other" would be where you would add to the formula if you wanted to display something when the number was 0, 2, or 3.

 

See this post on nested if's  for more on that.

https://www.smartsheet.com/blog/support-tip-build-nested-IF

 

Hope this helps.

 

Craig

 

Sally Osborne

Thanks. It works. So simple