Creating a formula based on a single select field

[Bob_Tambornini]

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

[kuovonne · Accepted solution]

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. ")
  )
)

[Bob_Tambornini]

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