display a single column content if Other is selected

OshaK

I have a salutation column which we use in one of the automation, but one of the options is Other where we allow our users to enter the custom one. I combine them in a single column as

=JOIN(Salutation@row:[Other Salutation]@row)

for that automation, but then it gets clumped like 'Otherother'. How can i combine both column but only display Other salutation without the Other from the first column.

markkrebs

one way is:

=if(isblank([Salutation]@row),[Other Salutation]@row,[Salutation]@row)

if you need a rule to check if both are blank of if a row is a parent then its a different if statement

markkrebs

one way is:

=if(isblank([Salutation]@row),[Other Salutation]@row,[Salutation]@row)

if you need a rule to check if both are blank of if a row is a parent then its a different if statement

OshaK

thank you, @markkrebs!