Jan 21, 2025 10:15 AM
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
Solved! Go to Solution.
Jan 21, 2025 11:03 AM
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. ")
)
)
Jan 21, 2025 11:03 AM
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. ")
)
)
Jan 21, 2025 11:26 AM
Thank you so much. Just learning how to use Airtable. Thank you thank you