I am trying to setup an automation based off of date column, where it will update a given status column based on the date range. i.e. if it’s between 2/1-2/28 it’ll update a status column to February.
Or if there’s another way to between section items based on dates when showcasing them in a dashboard view, that’s the ultimate goal.
Thank you
Hey @Rob_E3!
Whilst it isn’t currently possible to trigger an automation using the conditions “if date is between” I wonder if the following could work for you instead, simply using either a timeline column (specific to the start + end date of the month) or a date column (end date of the month)?
Let me know what you think!