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

jmo

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?

Andrée Starå

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!

Andrée Starå

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!

jmo

Yes sir - that's the stuff @Andrée Starå !!!

I really appreciate your quick reply.

Jeff

Andrée Starå

@jmoser

Excellent!

You're more than welcome!