Skip to main content

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

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 rblank 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!

Thanks a lot, that did the trick! Awesome!


Yay!

Reply


Terms & Conditions