In this board, we are tracking donations. I added the donation date and I need a hidden column to show the Month as Month and not as # from the donation date. This column will be used to form a chart. The formula I am currently using is MONTH({Donation date}) but this shows March as 3. Please let me know if you have any questions that will better help figuring out this formula. Thank you!
Hi @Sydney_Alma - while there may be a more efficient way to do this a simple SWITCH statement does the trick:
SWITCH(MONTH({Donation Date}),
1,“January”,
2,“February”,
3,“March”,
4,“April”,
5,“May”,
6,“June”,
7,“July”,
8,“August”,
9,“September”,
10,“October”,
11,“November”,
12,“December”,“”)
Thanks,
Mark
Hi @mark.anley
While it does work in a board, it will not work if mirrored. Here is a Loom video to show you what is happening and what I am trying to do. I hope this helps explain what I am trying to achieve.
Thank you,
Sydney
This might help:
FORMAT_DATE({Donation Date},"MMMM")
2 Likes
is there a way to have the month show but off of the Due date. For instance if something is due by Sept 9th, the month would show august?
Try this:
FORMAT_DATE(EOMONTH(FORMAT_DATE({Due Date}),-1),"MMMM")
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
1 Like