#### 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.

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

Options
edited 12/09/19

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?

• edited 03/03/17
Options

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

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
edited 03/04/17
Options

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

• edited 03/05/17
Options

Thanks. It works. So simple

This discussion has been closed.