How to create a correct formula dealing with 2 separate columns?

[maddoxs]

Is there a way that I can create a formula that shows if [Line of Business] = ""RR" than [Invoice Line Type] can be changed to say Rental Equipment? 

[FrederikE]

Hey @maddoxs,

I think

IF [Line of Business] = "RR"

THEN "Rental Equipment"

ELSE [Invoice Line Type] 

ENDIF

with the target column Invoice Line Type

is what you are looking for. 

[prpatel]

Yes.

Use a formula tool.  For the Output column select [Invoice Line Type]

Your formula will be

if

[Line of Business] ='RR'

then

"Rental Equipment'

else

[Invoice Line Type[

endif

try that.

-prpatel.

[Emmanuel_G]

Hi @maddoxs ,

Yes it is possible. Find a workflow attached with sample of your dataset to resolve this issue.

You can add this tool directly to your workflow. 

Let me know if there is any issue. 😃