Automating RYG balls based on checkboxes

I'm trying to create a function to accomplsh the following:

If coulumn 2 is checked, and column 3 is not checked, then the RYG ball in column 4 is green. If Column 2 is not checked, and column 3 is checked, then the RYG ball in column 4 is Red. When nothing in column 2 or 3 is checked, no RYG ball is displayed in column 4.

Any help?? Thanks

Find more posts tagged with

Formulas

Conditional Formatting

Comments

Wow, drank some coffee and solved my own problem. Lol. Here's the function:

=IF(AND([Column2]1 = 1, [Column3]1 = 0), "Green", IF(AND([Column2]1 = 0, [Column3]1 = 1), "Red"))

#nice

#nice

Hello,

Is it possible to create a function that will automate RYGB balls based on a column call "Status Details" with the following drop down options:

Not Yet Started - would like a blue ball

Review - would like a yellow ball

Complete - would like a green ball

Outstanding - would like a red ball

Thank you.

Totally dont understand what i am missing on this on
Can some one Help please, many many thanks!!!

=IF(AND([Due Date]1 < TODAY(), [Customer Sign off]1 = 0), "Red"))

J. Craig Williams

Clark,

Not quite sure.

Except for the extra ) at the end, it looks OK but did not work for me either (without it)

=IF(AND([Due Date]1 < TODAY(), [Customer Sign off]1 = 0), "Red", "")

adds the false condition, but that is not needed

=IF(AND([Due Date]1 < TODAY(), [Customer Sign off]1 = 0), "Red")

works too.

I retyped it and it works now.

(head-scratching)

Craig

Craig,

Awesome thank you so much!

=IF([Due Date]1 > TODAY(), "Green", IF([Due Date]1 = TODAY(), "Yellow", IF(AND([Due Date]1 < TODAY(), [Customer Sign off]1 = 1), "Gray", "Red")))

^^^^^^Final form! and it works awesome!!!

Thanks again, your lifesaver!

Sign in to join the conversation!

Quick Links

Trending discussions