Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for IF statement with Linked Accounts

Topic Labels: Formulas
Jump to Solution
168 2
Showing results for 
Search instead for 
Did you mean: 

I want to find a way to automatically mark a record as “Used” if it is linked to another table.

Is there a formula for an IF statement for “IF a field has information in it (if it’s NOT empty), add “Used””

Right now I have the following, but I’m receiving an invalid formula error message:
IF({field}, “USED”

Thanks in advance!

1 Solution

Accepted Solutions

Your formula should look like this:

IF({field}, "USED")

See Solution in Thread

2 Replies 2

Your formula should look like this:

IF({field}, "USED")

Thank you! This worked great!