If column A contain X - display value of column A, if contain Y, display value of column B

Hello guys,

I’m just getting started with Airtable formulas and couldn’t find the right formula for this scenario and will be grateful if you could help here.

I’ve 2 columns when based on the value on column A I want to determent if to display a value of column A or column B in the D column.

= If column A contains 1 or 2 or 3, then display the value of column A, if contain Y, display value of column B

Thanks

It would be something along these lines:

IF(OR (FIND (“1”, {Column A}), FIND (“2”, {Column A}), FIND (“3”, {Column A})), {Column A},
IF(FIND(“Y”, {Column A}), {Column B}))

1 Like

@Jarvis_Digital hanks but I’ve tried this and didn’t work.

Can you have a look?
IF(OR (FIND (“Office”, {Workplace}), FIND (“Hybrid”, {Workplace}),{Company - Location},
IF(FIND(“Remote”, {Workplace}), {Workplace}))

You’re missing a closing parenthesis for the OR() statement.

If “Office”, “Hybrid”, and “Remote” are the whole values of the field {Workplace} you could simplify the formula by using a SWITCH() statement.

SWITCH(
   {Workplace},
   "Office", {Company - Location},
   "Hybrid", {Company - Location},
   "Remote", {Workplace}
)

Edited to remove extra comma.

2 Likes

Where exactly?

It didn’t work as well…

I’m running out of ideas…

The formula you pasted looks like this: OR(FIND(), FIND(). It needs to look like this: OR(FIND(), FIND())

Be more specific. It produced an error and wouldn’t let you save the formula? Its not showing the desired result?

1 Like

You have an extra comma. Remove the comma after {Workplace} and before the closing parenthesis.


You have multiple syntax issues with this formula, include issues with extra spaces after your function names, curly quotes, and missing parenthesis.

Try this …

IF(
    OR(
        FIND("Office", {Workplace}), 
        FIND("Hybrid", {Workplace})
    ),
    {Company - Location},
IF(
    FIND("Remote", {Workplace}), 
    {Workplace}
))
2 Likes

Good 'ol syntax issues, lol

3 Likes

Thank you. It does the job perfectly!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.