Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with IF() formula (double IF?)

Solved
Jump to Solution
186 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all, so I have this situation in which I would need to use a double IF.

- Chechbox Field
- Formula field where: IF checkbox is selected > Value1; if not selected > Value2

- Then I have a subsequent Single Line Text field in which I need to have another IF in the formula field above where: IF this field is NOT empty > Value1.

Attached are a couple of screenshots. I have the first IF formula down already, I can't come up with the other one. In the second screenshot, where "DANIELA" is typed on the last field, the IF formula should bring me back to "OK" (Value1).

Hope I made myself clear enough, would be super helpful if anybody could help me!

Thanks

1 Solution

Accepted Solutions

Am making some assumptions about what you're looking for - I might be wrong. What it sounds like you want is
1. If or Daniela > OK
2. If ️ or [blank text field] > Compila date contatto

IF(OR({Checkbox Field}=1, {Single Line Text Field}), "OK", "Compila date contatto")

 

See Solution in Thread

3 Replies 3

Am making some assumptions about what you're looking for - I might be wrong. What it sounds like you want is
1. If or Daniela > OK
2. If ️ or [blank text field] > Compila date contatto

IF(OR({Checkbox Field}=1, {Single Line Text Field}), "OK", "Compila date contatto")

 

Thanks a lot, that did the trick! Awesome!