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
How to bring info from a different table view to my formula
+17Hi @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?
+17Thanks, 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
+17But 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.