Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF THEN Formula Help Needed Please!

Topic Labels: Formulas
531 1
cancel
Showing results for 
Search instead for 
Did you mean: 
awhitaker
4 - Data Explorer
4 - Data Explorer

I am struggling to figure out an IF/THEN statement that includes an OR. Here is what I'm needing it to do.

I want to say "If there is anything populated in Column A, I want it to pull it into Column C. And if there is anything populated in Column B, I want it to pull into Column C, as well." 

Here is my current formula       

IF(OR({DMSID Formula},{EG DMSID Formula}),{DMSID Formula},{EG DMSID Formula})
 
This is pulling in "Column A" (DMSID Formula) into "Column C", but it is not pulling in "Column B" (EG DMSID Formula). 
 
Any suggestions??? I appreciate any help that anyone can provide!
1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

It is easier to write these formulas if you share screen captures with sample data and sample results.

If you want the contents of {Column A} and {Column B}, you can just show both. If either is blank, it won't show anything. Note that if you want something other that a space between the column values, this particular formula will not work.

TRIM(CONCATENATE(
  {Column A},
  " ",
  {Column B}
))

 If you don't want to show {Column B} even if it has a value when there is no value for {Column A}, you can try something like this.

TRIM(CONCATENATE(
  {Column A},
  " ",
  IF({Column A}, {Column B})
))

And another option, just for fun because there are so many ways to do things in code. This one will also only show {Column B} if {Column A} has a value. This one lets you put any characters you want between the two values.

IF(
  AND(
    {Column A},
    {Column B}
  )
  {Column A} & ", " & {Column B},
  {Column A}
)