Skip to main content
Solved

Formula for IF statement with Linked Accounts

  • July 21, 2022
  • 2 replies
  • 30 views

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!

Best answer by ScottWorld

Your formula should look like this:

IF({field}, "USED")

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • July 21, 2022

Your formula should look like this:

IF({field}, "USED")


  • Author
  • New Participant
  • July 22, 2022

Your formula should look like this:

IF({field}, "USED")


Thank you! This worked great!