The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...