Automation - Select "January" in a multiple select field when a date field on that entry is between 1/1/22 and 1/31/22

Hi Airtable community! I’m new here and am building out a budget table for work. I’m trying to create an automation that updates an entry to say a certain month in a field when the date in the field next to it is within that month. For example, if money was spent on a “photographer” on 1/15/22, we will enter the exact date in one field (with a date field type) and then I want the field next to it to automatically change to “January” (with a multiple select field type). Can someone help me figure out how to automate this?

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