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.

Best Answer

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Answer ✓

    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