I have a Contracts table that includes a reference column to my Partners table.
I want to add a Formula attribute to my Contracts table that says something like IF(Partners = “foobar”…)
However, the formula field isn’t giving me the option to use Reference tables.
Hi @afichtner, welcome to the community!
Indeed, our formulas for now work with only certain fields - text, number, date and labels. You can read more about using formulas here: https://startinfinity.com/help/1.0/attributes/formula#app.
Cheers!
Are there any plans to allow formulas to use reference columns? I want to do this too.
Hi @oijess 
Unfortunately we are not going to be focusing on our formulas at the moment, the most recent update was released a few months ago and it included a better and improved version of our formulas (hyperformulas).
However, when it comes to improving them further, we are planning on introducing other attributes to our formulas, at the moment - I am unable to tell you which attributes we are going to include, but - when the time comes, I’ll make sure to post an update here.
Thank you for your understanding 