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
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!