Need help w/formula to provide text output based on specific criterion

Options
jmo
jmo ✭✭✭✭✭✭
edited 02/12/21 in Formulas and Functions

Hi team - I have a sheet that I use that has a column called "Type" and based on the type selected (drop-down menu) I need the MII/SLOD/3LOD column (currently a drop-down list) to provide specific text.

So if the following "types" are selected, I need the appropriate text to appear in the MII/SLOD/3LOD column (sub-bullets are the drop-down options of this column):

  • 1st Line Control Testing 
    • FLOD/MII
  •  1st Line Management Identified 
    • FLOD/MII
  • 2nd Line Compliance Self-Identified
    • SLOD
  • Audit Identified
    • 3LOD
  • Compliance Identified
    • SLOD
  • Compliance Testing
    • SLOD
  • DE Assessment Identified
    • FLOD/MII
  • ECORT-IT
    • SLOD
  • Risk Management Identified
    • SLOD 


What's the best way to go about this?

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @jmoser

    I hope you're well and safe!

    Try something like this. (and add the other options)

    =IF(OR(Type@row = "1st Line Control Testing"; Type@row = "1st Line Management Identified"; Type@row = "DE Assessment Identified"); "FLOD/MII")

    Depending on your country/region, you'll need to exchange the comma to a period.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

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

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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!