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
Jul 21, 2022 02:28 PM
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!
Solved! Go to Solution.
Jul 21, 2022 03:03 PM
Your formula should look like this:
IF({field}, "USED")
Jul 21, 2022 06:05 PM
Thank you! This worked great!