Hi there,
I’ve recently discovered Airtable and am in the process of migrating my Excel spreadsheet to an Airtable base, but cannot seem to copy dates from Excel to Airtable.
When I try copying dates, only some of them are copied over to Airtable, bu...
Hi there!
I’d like to be able to automatically calculate quarterly summaries in a table. I have different types of jobs and I’d like to be able to see how much I earned each quarter per job type, and in total (so all of the job types combined). So ba...
I figured out how to do it, all I had to do was change the formatting in Excel to long date format (so I had dates like “January 23rd, 2017” instead of “23-01-2017”), and then I could copy them over to Airtable perfectly.
Thanks anyway for your help!
Hi Andrew,
The field is already customized as a date field, but it still doesn’t work. I find it weird that random cells are filled in (though they are in the wrong format), but most of the cells are blank.
