This is actually a solution, but the request is to have some centralised “solutions” database somewhere for common problems like this, as I’ve literally been using bad workarounds for this problem for around 2 years now.
How to Group dates by Month:
If the Date is in column named “Date”,
- add a new column named Year/Month
- insert formula Date(Year([Date]), Month([Date]), 1)
Result:
- New column converts all dates to the relevant Year and Month, while flattening all to the 1st of the month
- This allows grouping by month, and sorting by month
Hi @Adam_Maggs
I am also interested in this, and there have been one or two attempts over the years to get something like this done. How do you envisage this working? A publicly shared Coda doc? A solutions area in the community?
I think that one of the major drawbacks has always been that a lot of effort is involved, with no remuneration.
R
P
BTW,
I have a free doc here with some suggested solutions:
I am open to making this a digital garden.
And a paid doc here with more detailed explanations of Formulas (Half of the formulas and counting).
I also explain some concepts, like Table Order, vs Sort Order vs Entry Order, Epoch numbers and so on.
Let me know how it fits in with what you had in mind.
I think what would most make sense is for solution suggestions to be accessible from within Coda itself. Their help button is useful for things like access to their tutorials and so forth, but to have something like what you’ve put together here natively integrated and indexable via the help button would go a long way.
And what you’ve put together here is amazing! I have come across this via the forum more than once in the past years and has been a great help. I’ve made a similar collection myself - and more than likely even copied/pasted some from there into mine
1 Like
I don’t think it is going to be practical to put things like this in a help link.
Unless we can get AI assistance. to build formulas…
1 Like