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.
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
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
so b) Can I get the additional field of a lookup column, and use that in a workflow?