Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Trying to create a formula based on content of 3 different fields

Topic Labels: Formulas
Solved
Jump to Solution
258 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bob_Tambornini
4 - Data Explorer
4 - Data Explorer

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

Bob_Tambornini_0-1737483257763.png

thanks 

Bob

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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