Quickly add unique values to a single column

1

See screenshot for reference.

I’m trying to have a table with 365 rows (one for each day in the year) and I want to input the days date on every row in a single column

I don’t want to individually type into 365 rows. Anybody know how to do this quickly?

I’ve thought of formulamap() with a modify row command but can’t think of much more not can I make anything with

image
image2224×1668 260 KB

2

@Scott_Weir

If it’s a one time operation, the easiest method would probably be to drag out your 365 dates in a spreadsheet, and then paste that into a Coda date formatted column.

If the 365 days will be added incrementally over time and you want the date column to auto-fill, here is one possible way to achieve that:

1 Like
3

Thank you! That’s just what I needed

1 Like