Hello,
HELP! Working with a base containing formatted currency fields but when downloading CSV, the resulting import into MS Excel, converts the currency fields to TEXT.
Is there a way to override this so that currency remains as a number field?
Than...
Hello Airtable community
I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records.
Unfortunately, the sort function does not sort chronologically as ...
Hello
I have converted an Excel spreadsheet into an Airtable base.
In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered.
Is this possible in Airtable?
Kind regards,
Sally
Hi there,
I want to add a formula to result in a date.
I have a delivery date column. and I want formula to calculate a date 7weeks (49 days) before the delivery date. I have this working in Excel & numbers, but copying the formula into Airtable does...
Hi Kamille,
Thank you!
My fields contain text, numbers & multiple select fields in addition to the currency & formula fields:
BUT, you have just given me a clue - and I have managed to get it working but updating OS decimal & thousands separators an...
Hello Dimitris,
I have the text: $25.35
I have tried as you have suggested above, but the formula will not work (have changed B3 to be my target cell reference)
:frowning:
Hello Rebecca.
Thanks for he suggestion, BUT converting to a number before downloading the csv, still results in text, not number. Cannot be converted in Excel without retyping. Reads the decimal point as a full stop instead of decimal…
For now, will...