+2Hello,
I'm really new to Airtable and completely inexperienced with formula options.
I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what I need...
Here is an example
Best answer by Ben_Young1
When I drag the date field down it just duplicates it... it doesn't seem to add the following day.
It does (ex) May 11 2023, May 11 2023, May 11 2023 over 3 rows.
And not (ex) May 12 2023, May 13 2023, May 14 2023
You need to provide a sequence of initial data points, select all of them, then use the fill handle to continue the sequence.
You were doing this:
+22Hey @Estelle12!
@TheTimeSavingCo resolved this for you in this thread.
Is there something we're missing?
+2Using the #Value means I have to drag 1,2,3,4 and so forth endlessly for 365 days. As I currently understand it?
+22Using the #Value means I have to drag 1,2,3,4 and so forth endlessly for 365 days. As I currently understand it?
If you're creating records for unique days of a calendar year, your fundamental data object is a date.
With that in mind, why are you choosing this method over just using a date field as your primary field?
+2When I drag the date field down it just duplicates it... it doesn't seem to add the following day.
It does (ex) May 11 2023, May 11 2023, May 11 2023 over 3 rows.
And not (ex) May 12 2023, May 13 2023, May 14 2023
+22When I drag the date field down it just duplicates it... it doesn't seem to add the following day.
It does (ex) May 11 2023, May 11 2023, May 11 2023 over 3 rows.
And not (ex) May 12 2023, May 13 2023, May 14 2023
You need to provide a sequence of initial data points, select all of them, then use the fill handle to continue the sequence.
You were doing this:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.