Help

Can custom formatting be applied to columns in Airtable?

Topic Labels: Base design
Solved
Jump to Solution
756 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sally_de_Witt
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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.