I am brand new to SF and formulas. I don't know the syntax for this.

I have a Picklist with a bunch of selections. The last selection is "Other" when this is chosen, I want the value a separate field put into the Picklist. So if a person chooses Other, they then fill out a blank field. That field's value would go into the Picklist.

This wrong(syntax is wrong for a Picklist), but might give you an idea of what I am trying to do:

IF (
ISBLANK(Relationship__c),
Relationship__c=Text(Woo_Other_Relationship__c))

What I want to do in the simplest of terms is this:

IF (Relationship__c = [NULL or Blank]) THEN (Relationship__c=Woo_Other_Relationship__c)

I am brand new to SF and formulas. I don't know the syntax for this.

I have a Picklist with a bunch of selections. The last selection is "Other" when this is chosen, I want the value a separate field put into the Picklist. So if a person chooses Other, they then fill out a blank field. That field's value would go into the Picklist.

This wrong(syntax is wrong for a Picklist), but might give you an idea of what I am trying to do:

IF (
ISBLANK(Relationship__c),
Relationship__c=Text(Woo_Other_Relationship__c))

What I want to do in the simplest of terms is this:

IF (Relationship__c = [NULL or Blank]) THEN (Relationship__c=Woo_Other_Relationship__c)