Check if no error then only show one field

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. :slight_smile:

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

3 Likes

@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. :+1: :slight_smile:

1 Like

In that case, just AND(A VALID IF, B VALID IF)

1 Like