Using contact location field as variable in a formula

Hello everyone! I have a formula field, and I want it to apply a different formula if there is a contact in the row whose location is Madrid, Spain. Can I retrieve this field and use it as a variable in the formula? Thank you!

Hey Marcelo!

Yes, if the “Madrid, Spain” value is in a Location Column or Text Column, it can be used as a field in your formula!

If it’s a text column, you will want to use an IF function formula and then put “Madrid, Spain” in quotations so that the formula searches for the text value.

I hope this helps!

Sorry, the thing is the location is a field in the Contacts board, which is connectes as a subitem in a column. So my question is if I can retrieve the value Location in a formula woth an If. Thanks!!