Skip to main content

First post, so I am sorry if this is not clear as to what I am trying to do.  My goal is to have a formula in a field determine if 3 different fields are either blank or not blank.  Depending on whether they are blank or not return a message to that formula field outlining what is missing and required.   See picture below.  I have tried to nest IF functions using blank or not blank, but I keep getting errors.  I have also tried to use the AND and OR functions in combination with the IF function with no luck.   A formula would work best for us.   Any ideas would be greatly appreciated

thanks 

Bob

 

You could try something like this. It isn't the exact output you want, but may be close enough.

IF(
AND({CUSTOMER}, {LEVEL}, {PART NUMBER}),
"Confirm part number",
CONCATENATE(
IF(NOT({PART NUMBER}), "Input part number. "),
IF(NOT({LEVEL}), "Select level. "),
IF(NOT({CUSTOMER}), "Select customer. ")
)
)

You could try something like this. It isn't the exact output you want, but may be close enough.

IF(
AND({CUSTOMER}, {LEVEL}, {PART NUMBER}),
"Confirm part number",
CONCATENATE(
IF(NOT({PART NUMBER}), "Input part number. "),
IF(NOT({LEVEL}), "Select level. "),
IF(NOT({CUSTOMER}), "Select customer. ")
)
)

Thank you so much.   Just learning how to use Airtable.   Thank you thank you

Reply


Terms & Conditions