Help

IF Statement Help Needed

Topic Labels: Formulas
1007 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cristy_Wildenbe
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

Hi @Cristy_Wildenberg,

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

5f73751092c6afb3485d0dfe997b3809227f5002.png

Guide to formula, lookup, count, and rollup fields

Formula, lookup, count, and rollup fields (columns) are powerful field types that allow you to compute a value based on values in other cells. These fields are configured in the field configuration...

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.