Reference cell from another container within the same workflow.

[wonka1234]

Hi,

I am trying to make a formula in my workflow but I want to use another number from another container.

I have this (A):

and I want to bring 

I just want to bring in the one row.. which is weird as I have many rows in (A)

Is this possible?

[IraWatt · Accepted solution]

Hey @wonka1234,

If think you will want to use the append fields tool to add that data to each row from A so you can apply your formula on each row and use the data column as a variable.

You may need to select Allow all appends.

Any questions or issues please ask :)
HTH!
Ira

[IraWatt]

Is this value always going to be the same? If yes you could create a workflow constant and use that in your formula: