Is there an expression (or community trick) to create a conditional expression that does nothing if it evaluates to false? My use case is that I want one Y/N column to be N if another one is true, but otherwise leave the value up to the user. IF always wants an ELSE and IFS without an ELSE evaluates to NULL which is not what I want.
You can use SWITCH in the initial value, like:
SWITCH([Option1],
"Y","N",
""
)
@Heru I tried your suggestion and it is the same outcome as my IFS expression. Instead of โDo Nothingโ these expressions force the value to NULL.
Hmm, maybe different understanding. Sorryโฆ
I just test it and look like this:
Hi @Heru,
As per my understanding, when the Option1 is โYโ , @Jamie wishes Option2 to be only โNโ, thereby giving no choice to the user to select โYโ for Option 2 when Option 1 is Y, something like below
When the Option 1 is N, then user can select both choices from Option 2
So I believe, our initial condition expression achieves similar results. Just that an additional Editable_if condition as described above does not allow the user to select any choice when the Option 1 is โYโ
Edit: Of course my understanding could be incorrect.
Can you elaborate more? There are several possibilities, but Iโm not sure which might be appropriate for you.
I have two Y/N fields: On Hold and Reference Only. If On Hold = Y then I want Reference Only to be N. But if On Hold = N then I donโt want to predefine a value for Reference Only. I donโt want it to be NULL, I want the user to be able to select the value themselves. I tried this expression for Reference Only:
IFS([On Hold],FALSE)
But that sets it to NULL (and hides the field) if On Hold is set to N. And of course:
IF([On Hold],FALSE,TRUE) will explicitly set it to the opposite of On Hold
Does this help?
Please try with following settings for [Reference Only] field
Initial Value as below
IFS([ON HOLD]=TRUE, FALSE)
Editable_if constraint as below
[ON HOLD]=FALSE
Thanks gents - Iโll try again today. To clarify, I had been putting the conditional expression into the columnโs formula not the initial value.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |