Help

Can custom formatting be applied to columns in Airtable?

Topic Labels: Base design
Solved
Jump to Solution
338 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.

Labels