Why is this lookup field not blank? (middle record)
Here’s the formula in the {formula} field:
IF({Chosen Status}!=BLANK(),"not blank","blank")
(also tried it with ARRAYCOMPACT around {Chosen Status})
This may have something to do with it: the look...
Hey @Bobby_Shiffler! Internally, yes, but the dev and release of it has taken a backseat to my core freelance work, which has been keeping me plenty busy these last few months. It’s definitely still on my mind, and I’m looking forward to putting more...
Hey @Mark_Ryan, I’m building a Gmail add-on for Airtable. Are you still looking for a solution? If so, I’d be interested to hear what you’d like to see in it, if you have any specific requests. When it’s ready for testing, you can also get an early g...
As far as I can tell, this is not supported currently. I would be interested in hearing if this is on the roadmap.
I imagine it would likely be implemented as an optional item for each single-select field, as it’s clear to see many times when the us...
Now that is curious.
It seems like your formulas are indeed working as intended. Are they currently using the empty string? (The field descriptions show the formulas using BLANK() )
For the experiment, I replaced BLANK() in my misbehaving formula (g...
Well, isn’t that how it goes. I found a workaround right after posting (I promise, I did a good deal of trying and researching before posting :slightly_smiling_face: Still got that inspiration right after I wrote it all up).
And I’m still curious...
