I have multiple currency and its values in different list and Currency is lookup in the main list so user can select from dropdown and can enter its cost.

Main List field:

Currency- Lookup in main list. Currency list has currency field and exchange rate field which is number type field: user needs to select currency from dropdown options in main list

Cost - Number type: user need to enter values here

Based on the above inputs from user. I want to calculate Expected Cost

Expected Cost: exchange rate*Cost. Expected cost change when user change currency or cost.

1 Answer 1


I did a test, this requirement can be achieved,need to set one-step workflow.

Please refer to this post for more information: SharePoint List calculated column formula

Note that in SPO, workflow2010 has been deprecated, and workflow2013 can be used instead: enter image description here


Currency List:

enter image description here

Main List:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.