How to bring info from a different table view to my formula

[Oded_Stern]

Hi community,
I have two tables in my base.
I’m in table 1 and I want to create a IF formula and bring info from table 2 (from a specific view)
Is there a way to do that?
If not, can I do a formula that uses info from a different table on the same base?
Thanks

[Mohamed_Swella1]

Hi @Oded_Stern,

You cannot get info from another table into a formula directly. You have to create a Lookup field or a Rollup field, this is in case you have a Linked Record of course. Once you bring the info into the table, you can use it in your formula.

BR,
Mo

[Oded_Stern]

Thanks, I’ll try to see how to solve it.
I am able to bring the info, but it’s not filtered.
Can I filter it with a IF formula inside the rollup?

[Mohamed_Swella1]

In the rollup field no, but you can make the IF formula in the other table then rollup the new formula field

[Oded_Stern]

But then I will not be able to do the filter.

I have in one table homeowner and in the other table all the leases, I want to bring to the table of the homeowner just the current lease and not past ones

[Mohamed_Swella1]

Then you can better change the setup. Add a formula to the Primary field, something like Newest Lease, Home Owner Name. Then in the other table link the Newest Lease to the Home Owner and rollup that field.