Help

If Sale Price=BLANK do X, If Sale Price≠BLANK do Y - Airtable considers "$0.00" = BLANK

Topic Labels: Data Formulas
Solved
Jump to Solution
455 1
cancel
Showing results for 
Search instead for 
Did you mean: 
projectstart
4 - Data Explorer
4 - Data Explorer

I have a formula that I'm attempting to show "Sold" if tickets to an event have been sold, but if the tickets have not been sold, to display the number of days until the event. I already have another formula that will give me the number of days until the event.

Generally, the formula below is working - except for one scenario, when a ticket was sold for $0.00. You may wonder why a ticket would be sold as zero, but that indicates to us that the ticket was given away - as compared to just not used.

I've tried to use the presence of a value (my best working version below), and I've also tried to use the =BLANK variable, because if there is no sale at all then the cell has nothing in it, but Airtable seems to treat a value of $0.00 the same as BLANK.

So then I tried a variation of this formula with >=0 but then ALL values were returned as true - even values where there's nothing in the cell.

Here's what I have for a formula currently:

IF({Event Sale Price}, "Sold", {Days till Event})

The "Event Sale Price" value is currently configured as a currency value - and I'd prefer not to change that.

1 Solution

Accepted Solutions
projectstart
4 - Data Explorer
4 - Data Explorer

Well! I figured out a solution. If I modify the formula to use the "COUNT" property then a value of zero is still counted as 1, and a blank value is counted as 0. I then modified my formula to the following and it's working!

 
IF(COUNT({Event Sale Price})>0, "Sold", {Days till Event})

See Solution in Thread

1 Reply 1
projectstart
4 - Data Explorer
4 - Data Explorer

Well! I figured out a solution. If I modify the formula to use the "COUNT" property then a value of zero is still counted as 1, and a blank value is counted as 0. I then modified my formula to the following and it's working!

 
IF(COUNT({Event Sale Price})>0, "Sold", {Days till Event})