Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Create new records for [Monday of the week of created time] - [Sunday of the week of created time]

Topic Labels: Formulas
415 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ritchie_Wong
4 - Data Explorer
4 - Data Explorer

Hi Airtable community, first time posting here. Thanks for your help in advance.

So, I'm trying to create something like YC Startup School weekly update forms: every new record will be named as "[Monday of the week of {created time}] - [Sunday of the week of {created time}]". 

Just like this:
Screenshot 2023-08-18 at 7.13.18 PM.png

I'm very new to using formulas, but would really love to learn how that works.

Tried "Weekday", "Dateadd"

Ritchie_Wong_0-1692357410693.png

Got stuck right here. Thanks a lot!

 

0 Replies 0