Help with IF() formula (double IF?)

Question

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

Best answer by pressGO_design

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

pressGO_design · Accepted Answer

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 · Answer

Thanks a lot, that did the trick! Awesome!

Help with IF() formula (double IF?)

2 Attachments

3 replies

2 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded