Hello, everyone! Is there any way to use a value present in a ‘Relation’ column in calculations? I tried doing it directly, but I couldn’t. Any suggestions or alternatives to work around this limitation?
A relation is a link to a specific row or series of rows. It is not a link to a specific column. If you need a specific column from the related row, then you need a Lookup column to get the value out of the relation.
3 Likes
I understand that a relation is a link to a specific row or rows, and that I need a Lookup column to access a specific column from the relation. I’ve created the Lookup column, but I still can’t use the value directly in calculations. What else can I do to resolve this?
Is your relation a single or multiple relation?
To do what you want, it must be a single relation.
1 Like
It’s a unique relationship.
Do you have the ‘Multiple’ checkbox checked in your relation column configuration? If you do, then it’s a multiple relation. If you don’t then it’s a single relation.
1 Like