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!
Solved! Go to Solution.