Help

Help with IF() formula (double IF?)

Solved
Jump to Solution
1329 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Federico_Triulz
5 - Automation Enthusiast
5 - Automation Enthusiast

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
pressGO_design
10 - Mercury
10 - Mercury

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
pressGO_design
10 - Mercury
10 - Mercury

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

 

Federico_Triulz
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks a lot, that did the trick! Awesome!