I want a status column with Months. Whenever a new item is created, the current month is set for that item. I can’t figure out a way to make this happen. It seems simple, but nothing I’ve tried has worked.
1 Like
I am not aware of a native solution to this. I believe third party apps would be able to fulfill this though. Is that a solution you’d be open to?
No… it’s not really that important. It just seemed like there would be an easy solution I was missing.
I did see there was a 3rd party app I could use to cast a formula to a number field. That would’ve allowed me to create additional automations to get what I needed, but we’re not interested in adding 3rd party apps.
Regards
For those who would be interested in a 3rd party solution, the Advanced Formula Booster could do it easily.
I do something like this on my board. Make a Start Date column that uses an automation to set the value to the current date when the item is created. Then have a formula column that calculates the Month by using MONTH({Start Date})
Jay,
I did something similar and can calculate the value of the month with the formula. But formula columns are not an option for automations to change a status column. It requires a number column. If I could convert/cast the formula to a number column, it would work in theory.
Thanks!
Why does the Month need to be a status column? What are you trying to do with the month column after it’s been set?
For a Kaban view of the information as well as a dashboard view.
I see. yeah, I don’t see a way to do that natively. It would be nice if an automation could set a timeline column. good luck!