I have a two fields that I want to put into a formula field. I want the first field, and then if the second field is not blank, I want a line break or two, followed by the word 'Test: ' and the second field. How can this be achieved? The <br> + Test: should only appear if the citation field is not blank.
So if the second field is blank, it should be:
Field1
If not,
Field 1 + <br> + Test: Field2
I tried using Case to no avail, and can't even get this to work if I remove the <br> and just put in a space. Thank you!
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Altair
I have a two fields that I want to put into a formula field. I want the first field, and then if the second field is not blank, I want a line break or two, followed by the word 'Test: ' and the second field. How can this be achieved? The <br> + Test: should only appear if the citation field is not blank.
So if the second field is blank, it should be:
Field1
If not,
Field 1 + <br> + Test: Field2
I tried using Case to no avail, and can't even get this to work if I remove the <br> and just put in a space. Thank you!
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.