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
Solved
Can custom formatting be applied to columns in Airtable?
+1Best answer by Kamille_Parks11
You would need one field for the date, and another field (a formula) to format the date:
DATETIME_FORMAT({Date Field}, "MM ww")
Or you resign to use a single line text field and format the month/week num yourself.
+27You would need one field for the date, and another field (a formula) to format the date:
DATETIME_FORMAT({Date Field}, "MM ww")
Or you resign to use a single line text field and format the month/week num yourself.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.