Help

2 conditions IF formula

Topic Labels: Formulas
Solved
Jump to Solution
719 5
cancel
Showing results for 
Search instead for 
Did you mean: 
JoelRocha
5 - Automation Enthusiast
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.
Please help!
1 Solution

Accepted Solutions

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'
            )
        ),
        "✔",
        ""
    ),
    ""
)

See Solution in Thread

5 Replies 5
Ben_Young1
11 - Venus
11 - Venus

 

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

 

Sho
11 - Venus
11 - Venus

or use the switch function

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

 

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.  

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'
            )
        ),
        "✔",
        ""
    ),
    ""
)

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