Dec 01, 2023 01:29 PM
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.
Solved! Go to Solution.
Dec 01, 2023 01:34 PM
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!
Dec 01, 2023 01:34 PM
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!