Skip to main content

Hello!

I believe what I'm asking could be a fairly simple fix but been trying to figure out and see if anyone has a formula for this. I created a Task + time tracking sheet for my employees. I'm trying to see if when I put the due date for instance if something is due 04/04/2023 I'd like to see if there's a formula or automation to make a single select field as well to put the month in. So in this instance, the field would be "April 2024" 

Please let me know if anyone has a solution for this. Additionally, if anyone has any great time tracking/tasks ideas to add to my base please let me know!

Hmm, try creating a formula field with `DATETIME_FORMAT({Date}, "MMMM YYYY")` to get the format you want, and then use an automation to paste the value from that formula field into your single select field.  Might need to add a `DATEADD()` in there if you want it to be a year later

Your automation trigger would be "When record updated" and you could point it at the date field directly

Reply


Terms & Conditions