Combine multiple fields based on certain conditions

It looks like you're trying to create a formula that combines values from two columns, but you're encountering issues with extraneous slashes when only one column has a value. To resolve this, you need to ensure that the slash is only added when both columns have values. Here’s how you can adjust your formula:

IF(
AND({Column A} != BLANK(), {Column B} != BLANK()),
CONCATENATE({Column A}, "/", {Column B}),
IF(
{Column A} != BLANK(),
{Column A},
{Column B}
)
)

In this formula:

AND({Column A} != BLANK(), {Column B} != BLANK()) checks if both columns have values. If true, it concatenates them with a "/" between.
IF({Column A} != BLANK(), {Column A}, {Column B}) checks if only one column has a value and returns that value. It ensures that if only one of the columns has data, no extra slash is added.
Ensure that:

Column Names: Use curly braces {} around your column names correctly.
Blank Checking: Use != BLANK() to check for empty values.

This formula should correctly handle cases where:

Both columns have values: Combine with a "/".
Only "Column A" has a value: Return that value without an extra "/".
Only "Column B" has a value: Return that value without an extra "/".

Try using this adjusted formula and see if it resolves the issue with unwanted slashes.

Try this:

Thank you Saravanan for the response. The above formula still left the "/" mark character if only Column A or Column B had a value. Others in this thread provided a solution to get rid of the "/" mark when Column A or Column B had a value.

Thank you The TimeSavingCo. This formula works like a charm!

Thank you Alexey_Gusev. This formula works great! I appreciate how concise the formula is. 

@Alexey_Gusev with your solution above (from last Aug), is it possible to add addtioinal steps for my use case

If C = asset01

and A is blank and B is not blank, 'missing A'

and or A is not blank and B is blank, 'missing B'

and or A & B are blank, 'missing A & B'

and or A & B are not blank, 'all ok'

I hope that makes sense!

Todd

@Alexey_Gusev thank you!

How can I add a second Asset with similar rules?

If C = asset01

and A is blank and B is not blank, 'missing A'

and or A is not blank and B is blank, 'missing B'

and or A & B are blank, 'missing A & B'

and or A & B are not blank, 'all ok'

AND

If D = asset02

and E is blank and F is not blank, 'missing E'

and or E is not blank and F is blank, 'missing F'

and or E & F are blank, 'missing E & F'

and or E & F are not blank, 'all ok'

I don't get it. Conditions C and D are independent or they can affect each other? What kind of output you expect?
Could you please give an example? No need to expand A,B,E,F, suppose they all present or all absent
If C and D are independent, just copy the same formula with other letters and put & between them.
Possible flaw - is when you see 'all ok' and don't know - 'which all is ok" 🙂    I mean A&B both present or E&F

@Alexey_Gusev I appreciate the pushback, as it helped me rephrase my question. I'm looking to provide multiple notifications for one field; existing or missing: copy (3 fields), image (1 field), and URL (1 field)

Well, I added line breaks and it looks good, I think

@Alexey_Gusev This is next level! Thank you so much!!

@Alexey_Gusev one last question, is there a way to separate the responses with a ',' or ';' vs. a line break?

That's strange, but I never met such simple thing.
Maybe better solution exists. I would add ";" in the end of each text output except last
then remove possible trailing ';' in the end by wrapping whole formula  in a such way:

Of course, line breaks '\n' should be removed

@Alexey_Gusev so this?

 '\nMissing Image;') &
IF({Full URL + Reftag}='', '\nMissing URL') ) ';$',''

@Alexey_Gusev once again, thank you! much appreciated!