IF Statement Help Needed

Hello, looking for help on how to to create a formula that references text in another “cell” on a different table to complete the formula.

Here’s what I’m looking to do:
Create an “IF(logical, value1, value2)” statement formula for a column in table 1 in a base, that references a single cell from table 2 (within the same base) that contains text to be included as a one of the values?

Can someone advise if this is possible, and if so, how to go about doing it?

Thanks,
Cristy

Hi @Cristy_Wildenberg,

It sounds like you’ll want to make use of Linked records and Lookup fields here:

The Lookup field will pull the value found in the cell from “table 2” for the record that is linked over from “table 2” into “table 1”. That value from “table 2” can then be used in your formula.

Check out those articles in the Support pages and then post back if you still need help making that happen.

1 Like