- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2024 05:20 PM
Hello,
I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field. This formula doesn't cause an errors, but it only partially works. Does anyone know why this doesn't work?
IF(
{Status} = "Complete",
"Completed",
IF(
OR(
{Status} = "Low Risk",
{Status} = "Candidate"
),
"On track",
IF(
OR(
{Status} = "Medium Risk",
{Status} = "High Risk",
),
"At risk",
IF(
OR(
{Status} = "New",
{Status} = "Needs Investigation",
{Status} = "Need More Info",
{Status} = "Under Review",
{Status} = "On Hold",
{Status} = "Deferred"
),
{Status} = "Delayed",
IF(
{Status} = "Will Not Implement",
"Will not implement",
""
)
)
)
)
)
The following inputs work, but the others do not: Complete, Low Risk, & Will Not Implement
Thank you.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2024 10:42 PM
Hi,
use switch
SWITCH({Status},
"Complete", "Completed",
"Low Risk", "On track",
"Candidate", "On track",
"Medium Risk", "At risk",
"High Risk", "At risk",
.....and so on... )
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2024 07:39 PM
Try changing the line `{Status} = "Delayed"` to `"Delayed"`
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 24, 2024 10:42 PM
Hi,
use switch
SWITCH({Status},
"Complete", "Completed",
"Low Risk", "On track",
"Candidate", "On track",
"Medium Risk", "At risk",
"High Risk", "At risk",
.....and so on... )
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 25, 2024 11:00 AM
Thank you. This worked. I wonder why it's not documented (or at least not in the AirTable docs I found on formulas).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 25, 2024 11:34 AM
It is in Logical functions, third item under IF.
