Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If Empty, If Not Empty Formula

Topic Labels: Formulas
Solved
Jump to Solution
1763 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

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
Justin_Barrett
18 - Pluto
18 - Pluto

You’re close. Try this:

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

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

You’re close. Try this:

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

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