# 2 conditions IF formula

Topic Labels: Formulas
Solved
719 5
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast
IF({Status}='Complete','','')
IF({Status}='Billed','','')

It does not let me, how can I combine them for one formula?
The status section has 15 statuses, but only these 2 can go green.
1 Solution

Accepted Solutions
11 - Venus

Ooof... while I pretty broadly advise against the use of multiple select fields, here's a formula that does what you're looking for:

``````IF(
{Status},
IF(
OR(
REGEX_MATCH(
{Status},
'Complete'
),
REGEX_MATCH(
{Status},
'Billed'
)
),
"✔",
"❌"
),
"❌"
)``````
5 Replies 5
11 - Venus

``````IF(
OR(
{Status} = "Complete",
{Status} = "Billed"
),
"✔",
"❌"
)``````

11 - Venus

or use the switch function

``````SWITCH({Status},
"Complete","done",
"Billed","done",
"x"
)``````

5 - Automation Enthusiast

Since it has multiple options in status, I need to select COMPLETE when a driver completed the route and I will go Green

` "✔"`

And when I bill the route, I have to select BILLED option too, but when I use this formula, it comes back with an X becouse I selected 2 options, the Complete and Billed.
The task is to, when I multi-select Complete and Billed, it should be Green Check point. If there any other options, well X is fine.

11 - Venus

Ooof... while I pretty broadly advise against the use of multiple select fields, here's a formula that does what you're looking for:

``````IF(
{Status},
IF(
OR(
REGEX_MATCH(
{Status},
'Complete'
),
REGEX_MATCH(
{Status},
'Billed'
)
),
"✔",
"❌"
),
"❌"
)``````
5 - Automation Enthusiast

Waw, works great. Thank you!!!! 💪