Skip to main content

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

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

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


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?

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?


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

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

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


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.

Reply


Terms & Conditions