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
Sally Osborne
edited 12/09/19 in Archived 2017 Posts

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?

Comments

  • Carter Leffen
    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

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    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.  

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    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

     

  • Sally Osborne
    edited 03/05/17
    Options

    Thanks. It works. So simple

This discussion has been closed.