Adding a column populated by an IF statement.

[SflynnAZBlue]

I have created a workflow with most of the data that I need but now I need to add a new column that will populate an account number based on the location # column.  With the basic example below I need to add a new column that will be populated by an if statement.  If location = 1 then account number 12345.  I am missing how to create that new column so I can use a formula tool to populate it. Any help would be greatly appreciated.

Location  City           State  Zip code

1              Chandler  AZ      85225

2              Mesa        AZ      85234

3              Gilbert      AZ      85241

[Felipe_Ribeir0]

Hi @SflynnAZBlue 

You can create this new column with the formula tool, like this:

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

Thanks.

[SflynnAZBlue]

That work great.  Thank you!

[Felipe_Ribeir0]

No problem :)

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

Thanks.