Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

joelgabauer
5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Oct 19, 2020
‎Aug 21, 2024

User Statistics

  • 3 Posts
  • 0 Solutions
  • 3 Kudos given
  • 5 Kudos received

User Activity

Hi All, I’d like to create a unique number for a record based on the year and week. So for example, I have a date field which I use as YEAR(Date)&" - "&WEEKNUM(Date). So if the date was today this would give me an output of 2020 - 43. Now, I want to ...