The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
I have a table with tens of thousands of rows, and one non-unique column is ‘asset type’. I can group by asset type, then view the sums of other data columns by that grouping. That’s 80% of what I need!
Now I need to calculate several formulae based ...
I just used CSV Block to import for the first time. My table was initially created with the base CVS import.
The CSV schema I’m importing does not have any unique column. However, a set of three columns is unique. I made my primary field, id, a formu...
The conditional aspect in your screenshot seems potentially useful, but I need to overcome several challenges:
I need sums, not counts. Can I sum conditionally (so if a record doesn’t meet the condition it contributes 0 to the sum)?Would I need to cr...