Red flag alert

09/15/21
Answered - Pending Review

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.

Answers

  • Jason AlbrechtJason 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å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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

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

  • Andrée Starå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!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.