Skip to main content

Hello. I’m very new to Airtable and need an assist!

 

  1. I have this formula in Google Sheets:

 

=BYROW($G$15:$G,LAMBDA(i,IF(i="",,VLOOKUP(i,$F$1:$G$2,2,0))))

 

VLOOKUP references this lookup table:

 

1 UsedLikeNew
2 UsedVeryGood
3 UsedGood
4 UsedAcceptable
5 CollLikeNew
6 CollVeryGood
7 CollGood
8 CollAcceptable
10 Refurbished
11 New

 

If a number there matches a number in a column  starting in cell G15 (via BYROW), then it returns the category in the lookup table associated with that number. So the column might be:

 

3

5

7

4

10

 

And the formula would convert these to:

 

UsedGood

CollLikeNew

CollGood

UsedAcceptable

Refurbished

 

What’s the easiest way to create this in Airtable?

 

  1. I also have a similar issue with this lookup table, but not with numbers:

 

AMAZON_NA FBA
DEFAULT FBM

 

So I have a column that says either AMAZON_NA or DEFAULT and want to convert these to either FBA or FBM. I used =VLOOKUP(F15, $A$1:$B$10, 2, FALSE) in Google Sheets. I assume the logic would be the same as in the first lookup table above?

 

It would be a little easier to help if we knew what the current layout is.  But typically to solve your first question, you can used a formula to look at that number field, or whatever selection field you want to use, and have the formula switch the numbers out for the condition.

I would use a ratings field, choose whatever symbol you think is cool for your product, each star is a number to a formula, so if  ⭐️⭐️ was selected in the rating field the formula will display “UsedVeryGood”. The last line is if no rating is selected the formula will display “Unknown Condition”

 

SWITCH(
    {Rating Field},
    0, "No condition selected",
    1, "UsedLikeNew",
    2, "UsedVeryGood",
    3, "UsedGood",
    4, "UsedAcceptable",
    5, "CollLikeNew",
    6, "CollVeryGood",
    7, "CollGood",
    8, "CollAcceptable",
    10, "Refurbished",
    11, "New",
    "Unknown Condition"
)

Yes, same logic for the next question as well.

SWITCH(
    {fieldName},
    "AMAZON_NA", "FBA",
    "DEFAULT", "FBM",
    "Unknown"
)

Good luck, let us know how it goes!

Reply


Terms & Conditions