Bookseller here trying to survive by listing on Amazon. I have lots of books that are so old ISBNs didn’t exist when they were published. For those books, Amazon offers what they call a “GTIN” exemption. So I have two fields: (1) a single line field called {Product ID}, which contains an ISBN if available, but is, otherwise, left blank; and (2) and a formula field called {Product ID Type}, which needs to contain “ISBN” if {Product ID} is NOT blank or “GTIN” if {Product ID} is blank. I have no idea what might work here. Fingers crossed that one of you do. :slightly_smiling_face:
Solved
If not blank, copy value; if blank, enter "GTIN"
+14Best answer by Jeremy_Oglesby
Hi again, @Alba_Machado2 :slightly_smiling_face:
IF({Product ID}, "ISBN", "GTIN")
+14Hi again, @Alba_Machado2 :slightly_smiling_face:
IF({Product ID}, "ISBN", "GTIN")
So elegant! Thanks again! I’m feeling significantly less overwhelmed by the prospect of having to create a table that accommodates Amazon’s 200+ fields in order to save my little old book business. :green_heart: :green_heart: :green_heart:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.