Red flag alert

penny53731

I am hoping someone could help me, (I have also attached a snippet ). i have a few columns that have an OK or Defect as a drop down choice. My first column is a red flag alert. I need a formula or something to help with - IF one of the columns in that row say defect it changes the red flag in column one to red. That way i can put a notification to the project manager if there is a red flag raised,

red flag formula.docx

there is a defect that has come in for that location.

Jason Albrecht

Hi Penny,

I'm assuming that any of the example columns that have "OK" in them may also have a "Defect" option as well?

In this case, maybe using a combination of IF(OR(... where if true, 1 turns the flag to red, otherwise 0)

e.g.

= IF ( OR ( [DAILY Tyres & Wheels]@row = "Defect", ..., [WEEKLY Coolant] = "Defect"], ..., 1, 0)

the ellipsis (...) above would be the names of the other columns as per the other two examples.

Hope this makes sense?

There's likely a more elegant solution which someone else may offer, but hopefully this helps in the meantime.

Andrée Starå

Hi @penny53731

I hope you're well and safe!

To add to Jason's excellent advice/answer.

Try something like this. (update the columns to include the whole range)

=IF(CONTAINS("Defect", [DAILY Tyres & Wheels]@row:
[MONTHLY Grease & Spray applied]@row), 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!

penny53731

Thank you very much for all your help. I managed to get it right and super happy with myself today.

Andrée Starå

@penny53731

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!