Hi all- I have a table sourced by a CSV upload with properties and owner names (and lots of other fields) on single rows, 1 row per property. Some owners own multiple properties. I’m using Airtable to clean this up and separate the single row sourc...
I am encountering something strange- a checkbox brought onto my sheet from another sheet in the same airtable book is being recognized by formulas when it is checked, but is not being recognized when unchecked. The field is called 'Exclude" and this...
I’m trying to get the number of months remaining between an end date and today, as a whole integer. The specific use case is for monthly payments that occur during a month. By way of example, today is July 25th, and my end date is October 1, and t...
I have ended up with very wide tables (100+ col’s) that are hard to navigate in either grid view or as vertical tables. I would dearly love the ability to easily separate into separate tables on 1 to 1 relationship or group certain fields into a tab ...
I tried to put a negative number in a currency field and it was not allowed, got an error popup asking me to use a formula instead. This seems like a glaring omission- surely others use positive and negative currency values?
I have a count of the properties per owner using the ‘giant rollup method’ and i must confess, I do not understand the formula being used but it works… However i don’t know how i’d create a separate table of owners from the single flat file source da...
thx for your suggestions. There was never a situation where NOT(Exclude) worked
I resolved the scenario in a different way and had to use -IF(Exclude = BLANK(),0,{my desired outcome},0)
as t his was the only way the lack of a checkbox was recognized
anyone know how to post a publicly accessible link to a base? i put the scenario into a base showing why a lookup checkbox does not respond to the NOT formula while a local sheet checkbox DOES respond to the NOT formula. Pretty clear, the lookup f...
the point is, airtable does not recognize NOT(Exclude) where Exclude is a checkbox brought in via lookup. It DOES work when Exclude is a checkbox on the sheet itself
This appears to be an airtable problem where a checkbox = true or false on one shee...
I’ve created a clean base with only this issue isolated if anyone wants to look at it- not sure how to make a base public to post it here, however.
But this does appear to be a limitation of airtable and the lookup formula however- checkbox values t...
