I have 10 fields in a table, and some contain numbers and the others either a letter or a symbol, in the same table I would like to have another field that sums up the values of the numbers only in that record. Is there a simple way/formula to do this?
Does Airtable have an equivalent formula to excel’s SUMPRODUCT & ISNUMBER?
Another question, here is a simple base Airtable - Grid view
I would like to create 3 separate fields, one that counts up the number of DOTS in the 6 fields, one that counts the number of Ws in the 6 fields and one that counts the number of WKTS in the 6 fields.
What formula would I use for that please?