Formula Help for the newbie & simple fix I am sure....

[jaygerbs]

I think the picture below shows what I am after.  I am given the 1st column & want the 2nd column to be my output.  If there is a blank in the 1st column I want it to stay that way.

Thanks!

[Emil_Kos · Accepted solution]

Hi @jaygerbs,

I have prepared a workflow for you:

The formula you are looking for is :

IF [Company A] = 'My company' THEN 'My company' ELSEIF IsNull([Company A]) THEN Null() ELSE 'Not mine' ENDIF

The output:

If I misunderstood your request please let me know.

[jaygerbs]

Hey @Emil_Kos

That worked!  One other question, if it contains "my company" in the string, what do I need to add to the formula?

Thanks again!

[jaygerbs]

Hey @Emil_Kos

Disregard my last message.  Thanks, I figured it out.  I appreciate the help.

JG