Field conditional to date

This should be easy but i am not succeeding in getting it done.

I have a field named “month” and i want it to change according to a date field. If the date is in October i want that field to have the word “October”. I have it as a single select field but i would like it to be automatic. How can i do this? Be it an automation or function or zapier or whatever.

Thanks in advance.

Either convert the single select into a formula field, or create a new formula field, with this formula:

DATETIME_FORMAT({Date Field}, "MMMM")

If you want to keep your original single select field, use an Automation to copy the value of the formula field into the single select whenever the value of the formula field changes. This is going to eat into your monthly allotment of automation runs so this may not be sustainable without using a script to reduce the number of times the automation should run.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.