Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If Empty, If Not Empty Formula

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

I have a link field called Sale and a formula field called Status. What I want is for Status to say “For Sale” when the Sale field is empty, and for Status to say “Sold” when the Sale field is not empty. I swear I do try to search for answers in docs and previous forum discussions before asking here, and I’m so grateful for those of you who come through.

From a previous discussion, I used this formula which helped part of the way…

IF({Sale},{Sale}, “For Sale”)

I just don’t know how to add the “Sold”

1 Solution

Accepted Solutions

You’re close. Try this:

IF({Sale}, "Sold", "For Sale")

See Solution in Thread

2 Replies 2

You’re close. Try this:

IF({Sale}, "Sold", "For Sale")

That did the trick! Thanks so much!! :slightly_smiling_face: