I want to get the following result and I don’t know how to use the if function for that.
If (record is blank), CONCATENATE(a&b), CONCATENATE(b&c))
What should I do?
Thanks
Using If with a blank option
+29What fields in the record are blank? If A, B, and C are fields in the record, then there would be nothing to concatenate. If they are not fields in the record, you don’t need a formula.
If you you have specific input fields that would be blank, and other fields that would not be blank, you can create an if statement with those.
IF( AND({Input 1} = BLANK(), {Input 2} = BLANK(), {Input 3} = BLANK())
A & B,
B & C
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.