It would be great if you could use a formula column to auto-populate dates and then be able to create automations for notifications based on the date in that formula column. For example, we would like to enter the final due date for a project and use a formula column to auto populate another date that can be actioned against for notifications or other automations.
Yes!! So glad I found this thread. I have been trying for several days to find a work around with no luck yet.
I am trying to see some items in Calendar view but Calendar will only show items with a true āDateā column type even though the output of my formula is a date it cannot be seen there. It is really inhibiting my ability to create automations in Monday.com overall.
I am having the same problem with formulas with number outputs. I would love to have a function that forces the formula output to a specific data/column type.
Without a way to use formula columns with automations and calendar etcā¦ they are not very useful. Can we know what the plan is here? Can we hope for some sort of solution going forward?
3 Likes
I totally agree with you! It would be really nice to have that feature where the output of the formula can be used as an argument in an automation/integration.
1 Like
Adding my vote to this. We use a formula column to generate dates from text in another column. It would be awesome to be able to use these formula-dates in views like the calendar.
+1, This is crucial for automations.
I think this would be a really useful feature. The āWhen Date Arrivesā automation exclusively works with date columns, but there are times when I would really like to send out automated reminders to team members when a date that has been created through a formula arrives instead. Iāve had a nosy and not found a work around for this yet, so Iām hoping this is a feature that Monday will consider. Thank you!
1 Like
Has there been any update on this feature? Itās difficult to make a work back schedule as subitems without being able to recognize the formula date as an actual Date column!
I would like to vote for this feature also. Without it, the automations are very limited when involving dates, or result in manual input being required when it should not be needed. I was able to do this with Smartsheet without issue, and this has been the most disappointing thing with Monday. I have seen several forums requesting this over the past few years now. Why the delay for what would be such a useful feature?
1 Like
+1. Iām really surprised this is not available yet.
+1 for this feature. Seems a valuable addition for lots of users.
Not only would it be good for automations but in graphical dashboards as well. Currently, a formula column returning a formatted date doesnāt allow you to group by month or sort the dates properly when adjusting settings on a graph. You ether get ALL the dates, or if you change your formula output to MMM YYYY you get values grouped by month but then if you sort X ascending its alphabetical, not chronological.
I need this as well. For everything that can be done in the app, this seems fairly reasonable.