# IF statement... If one out two fields contains... then

Topic Labels: Formulas
Solved
1998 4
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hi everybody,

I’m struggling to find the right code for my formula.

I’m making a content calender in airtable. I made a text field “text input” and I made an attachement field “image”. My goal is to have a field that tells me the status of the content. What I’m looking for is a formula that kinda goes like this:

IF {text input} is empty then: “ :bell: write text”
IF {image} is empty then: “ :bell: upload image”
IF {text input} and {image} are empty then: " :bell: :bell: write text, upload image"
IF {text input} and {image} are not empty then: " :white_check_mark: Ready to go"

Can anybody help me how to get the right formula?

Also… (to make things interesting) I was wondering if there’s a way to add a “deadline” feature to the same formula. My question is: is it be possible to add something like this too:

IF {text input} or {image} is empty, and {deadline} is within 2 days, then “ :rotating_light: HURRY”

Hopefully someone can help me out with this.

Thank you guys so much for your time and efforts!

1 Solution

Accepted Solutions
10 - Mercury
``````IF(
AND(
{status} != " :white_check_mark: Ready to go"
),
“:rotating_light: Hurry”,
“:+1: on schedule”
)``````
4 Replies 4
10 - Mercury

Haven’t tested it so there could be errors, but you basically need to nest IF blocks. The indented version is just for readability. Run the minified one below it to debug.

``````IF(
AND({text input},{image}),
IF(
{text input},
IF(
{image}),
":bell: :bell: write text",
“:rotating_light: HURRY”,
" :bell: :bell: write text, upload image"
)
)
)
)
``````

Minified

IF(AND({text input},{image})," :white_check_mark: Ready to go",IF({text input},“ :bell: upload image”},IF({image})," :bell: :bell: write text",IF( DATETIME_DIFF({deadline},Today(), ‘days’) < 2,“ :rotating_light: HURRY”," :bell: :bell: write text, upload image"))))

6 - Interface Innovator

Thank you Zollie,

With your input I was able to make it work. Unfortunatly I also realised that adding the {deadline} field into the formula actually didn’t improve the “clear overview” I had in mind… Instead I think it’s better to separate them and make an additional field that goes like this:

If {deadline} is within 2 days, and status is not " :white_check_mark: Ready to go" Then “ :rotating_light: Hurry” , “ :thumbs_up: on scedule”

I tried using your previous reply as an example but for some reason it doesn’t recognise the difference between days. Could this be because the {deadline} field is also a formula field instead of an actual date field? It shouldn’t be tho… I made a calender view based on the same {deadline} field… So it should recognise it…

Any ideas?

10 - Mercury
``````IF(
AND(