Help

Using a linked field in a formula

716 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Danae_Daniilidi
4 - Data Explorer
4 - Data Explorer

Good morning,

I am trying to use an FX rate (which is a lookup field from another table) and a number value in a function. I have been using VALUE({FX}) * {Equity} where FX is the lookup fields and Equity is a number field. I am getting an Error for all lines and no error explanation.

Does anyone know how to fix this?

Thanks!

2 Replies 2

Hi @Danae_Daniilidis and welcome to Airtable Community :smiling_face_with_three_hearts:

Your formula is a good one. Can you provide screenshots?

Danae_Daniilidi
4 - Data Explorer
4 - Data Explorer

Hi Nathalie, I managed to get the formula to work by changing the data type of the field that was being pulled in the linked table to number instead of text! Thank you for your help!