Red flag alert
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,
there is a defect that has come in for that location.