Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with IF() formula (double IF?)

Solved
Jump to Solution
3109 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!