I have 3 Column fields in the form. A, B and C.
I need to show C field if And B has valid value means no error message for A and B.
AND(ISNOTBLANK(A), ISNOTBLANK(B))
will not work in my case because I have customized valid if for both A and B. Itโs not only blank check but entered value I am checking with DB also. There are many conditional expressions for both A and B so for field C, I do not want to combine it and write again for C.
I need expression like, AND(ISVALID(A), ISVALID(B))
So it will be good if I can just check if A has valid value and B has valid value then show field C.
Any suggestions would be great.
I believe youโll need to write a Show If expression for this C column that basically reinforces A and B Valid If.
So, assuming your Valid Ifs produce lists, perhaps something along the lines ofโฆ
AND(IN([A], **SAME AS A's VALID IF**), IN([B], **SAME AS B's VALID IF**))
@Bahbus
Valid If returns true false only. I wrote the below code and it works great for me.
AND(true = **SAME AS A's VALID IF**, true = **SAME AS B's VALID IF**)
Thanks a lot for giving me the perfect idea.
In that case, just AND(A VALID IF, B VALID IF)
User | Count |
---|---|
16 | |
10 | |
8 | |
5 | |
5 |