Background
I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists.
Voltage Cost
120 2.50
240 3.50
...
The other list is for people to fill out when they complete a task. This should use a lookup column to pull the price of a voltage from the list above and calculate a final cost.
I fetch it like so:
And would like to use it in the following way:
Voltage Voltage:Cost Hours Final Cost
120 2.50 1 =[Voltage:Cost]+[Hours]*10
240 3.50 2 =[Voltage:Cost]+[Hours]*10
a) Is it possible to use a lookup column/its additional field in the calculated field? I'm pretty sure not, but hopefully this can change because I can see people needing it for an application like this.
Question
I know that the typical workaround is creating a workflow that populates a column with the look up item. This works for Voltage
, but not Voltage:Cost
.
See, I have Voltage:Cost
, and I want to use the workflow to move that to Power Cost
, so I can calculate Yearly Cost
. However, in the workflow, I can only move over Voltage
, not Voltage:Cost
.
so b) Can I get the additional field of a lookup column, and use that in a workflow?
Thank you.