Airtable_Ops - profile

Airtable_Ops · Feb 07, 2020

I’m trying to write a formula which returns either a value from field A or a string within the formula, dependant on the value in fields B & C. Where the values in fields B & C are met then a value within the formula should be returned, when the valu...

Airtable_Ops · Sep 06, 2019

I have some views and even whole tables within my workspace that I want to lock so that no other users can view them. If I set a view to “personal view” then by default other users don’t see it, however other users with “creator” permissions can just...

Airtable_Ops · Aug 14, 2019

Hi, I have a table with 3 columns, “Usage”, “Clients” and “Status”. “Usage” is a single select and can only be “Platform” or “Client”. “Clients” is a link record that allows me to select multiple client records from another table. “Status” is a looku...

Airtable_Ops · Feb 18, 2020

Hi @Jeremy_Oglesby, apologies for the slow response I’ve been on holiday! Thanks so much for the suggestion I’ve managed to get the SWITCH statement working for the case I outlined. I’m now looking at having 2 separate conditions and then if neither ...

Airtable_Ops · Aug 14, 2019

@Claudio This works perfectly! You have no idea how long I spent trying to work this out, I can’t believe it was this simple. Many thanks

User Statistics

User Activity

Using if statements with multiple conditions

Views locked so nobody else can view them

IF AND where an argument contains a string within comma separated values

Re: Using if statements with multiple conditions

Re: IF AND where an argument contains a string within comma separated values