If Statement is null

Question

HI All,

Need some help

I have two columns called "LifeCycle Status" & "PersonId"

Where PersonID is populated (i.e. not Null) i would like add a new lifecycle status called "Operations"

I am thinking the formula to do this would be something along the lines of

IF IsNull([person_id]) THEN " " ELSE ";Operations"+[Lifecycle Status]" ENDIF

Current Data

Lifecycle StatusPerson ID Sales1111Sales;Marketing2222Sales Sales Sales;Marketing  3333

Expected Outcome :

Lifecycle StatusPerson ID LifeCycle OveralSales1111Sales;OperationsSales;Marketing2222Sales;Marketing;OperationsSales SalesSales SalesSales;Marketing Sales;Marketing 3333Operations

Looking forward to yourhelp

Felipe_Ribeir0 · Accepted Answer

Hi @Masond3

You could use something like this (workflow attached):

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.