I have this IF Statement Formula:
This is really only going to work if you only have these two options because you have to test both possible orders they can occur in within the string. The more options you add, the more possible orders you are going to need to test and the messier the formula will become.
IF({UNH Facilities}= "UNH Facilities - GH Cleared",
"🟣",
IF({UNH Facilities}= "UNH Facilities - Supplying Items",
"🟠",
IF(OR({UNH Facilities}= "UNH Facilities - Supplying Items, UNH Facilities - GH Cleared",{UNH Facilities}= "UNH Facilities - GH Cleared, UNH Facilities - Supplying Items"),
"🟣🟠",
BLANK()))
)
This is really only going to work if you only have these two options because you have to test both possible orders they can occur in within the string. The more options you add, the more possible orders you are going to need to test and the messier the formula will become.
IF({UNH Facilities}= "UNH Facilities - GH Cleared",
"🟣",
IF({UNH Facilities}= "UNH Facilities - Supplying Items",
"🟠",
IF(OR({UNH Facilities}= "UNH Facilities - Supplying Items, UNH Facilities - GH Cleared",{UNH Facilities}= "UNH Facilities - GH Cleared, UNH Facilities - Supplying Items"),
"🟣🟠",
BLANK()))
)
Thanks for the suggestion, I really appreciate it! I do only have those options. A colleague came up with this, which seems to work too:
IF(
{UNH Facilities}= "UNH Facilities - GH Cleared",
"🟣",
IF({UNH Facilities}= "UNH Facilities - Supplying Items",
"🟠",
IF(AND(SEARCH("UNH Facilities - GH Cleared",{UNH Facilities})>0, SEARCH("UNH Facilities - Supplying Items",{UNH Facilities})>0),
"🟣 🟠")
)
)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.