If/then with And function

I am new to writing formulas, but usually once I get the started, I can string things together. I am stumped on this one though. Can anyone help?

I need a formula for:

If Outreach stage = First Outreach call/email or Second Outreach call/email then Status is "Yellow"

IF Outreach stage =Discovery Call or Follow up post contact then Status is "Green"

IF Outreach stage = Follow up in 6 months or Follow up 1 year then status is "Red"

Below is the start of the formula and it changes to yellow.

=IF(OR([Outreach stage]@row = "First Outreach call/email", [Outreach stage]@row = "Second Outreach call/email"), "Yellow")

I have written about 10 variations of adding the other color statuses, lol.

What needs to be added to complete the formula below for all color status considering there is an "OR" variable for each status color. I confirmed that each string of the formula below works for each color if broken apart. Please help me string it together.

=IF(OR([Outreach stage]@row = "First Outreach call/email", [Outreach stage]@row = "Second Outreach call/email"), "Yellow"), =IF(OR([Outreach stage]@row = "Discovery Call", [Outreach stage]@row = "Follow up post contact"), "Green"), =IF(OR([Outreach stage]@row = "Follow up in 6 months", [Outreach stage]@row = "Follow up 1 year"), "Red")

Thank you in advance!

Answers

  • allison.worley
    allison.worley ✭✭✭✭

    2 minutes after I decide to post I figure it out. I'm leaving this here in case anyone else needs in the future but I answered my own question!


    =IF(OR([Outreach stage]@row = "First Outreach call/email", [Outreach stage]@row = "Second Outreach call/email"), "Yellow", IF(OR([Outreach stage]@row = "Discovery Call", [Outreach stage]@row = "Follow up post contact"), "Green", IF(OR([Outreach stage]@row = "Follow up in 6 months", [Outreach stage]@row = "Follow up 1 year"), "Red")))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!