+3Best answer by Ben_Young1
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'
)
),
"✔",
"❌"
),
"❌"
)
+22
IF(
OR(
{Status} = "Complete",
{Status} = "Billed"
),
"✔",
"❌"
)
+3
IF(
OR(
{Status} = "Complete",
{Status} = "Billed"
),
"✔",
"❌"
)
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.
+22Since 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'
)
),
"✔",
"❌"
),
"❌"
)+3Ooof... 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!!!! 💪
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.