Looking for an =If Function for a Check Box

Lori Cross

I am trying to write a =If Function to check a box if one of my health columns is yellow or red. I have looked in the community and research the function tool. Any suggestions?

Lori Cross

Thank you I figured it out

=IF(OR([Overall Project Health]@row = "Red", [Overall Project Health]@row = "Yellow"), 1)

Don Wilcox

Hi Lori,

Try this, =IF([health column]@row = "yellow",1, 0)

if your health column is yellow, then the if column = 1. If the health column is red, then the if column = 0.

Hope this helps.

Don Wilcox

drwilcox.57@gmail.com

Andrée Starå

Hi @Lori Cross

I hope you're well and safe!

Try something like this.

=IF(OR(Health@row = "Red", Health@row = "Yellow"), 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lori Cross

Thank you I figured it out

=IF(OR([Overall Project Health]@row = "Red", [Overall Project Health]@row = "Yellow"), 1)

Andrée Starå

@Lori Cross

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!