# To be able to use Formula in Automation filters **URL:** \ **Category:** Ideas & Features\ **Tags:** automations\ **Created:** [December 14, 2022, 3:43pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706 "2022-12-14T15:43:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![julien.erny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/julien.erny/32/5833_2.png) [@julien.erny](https://community.fibery.io/u/julien.erny)\ **Post date:** [December 14, 2022, 3:43pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/1 "2022-12-14T15:43:03Z")
Some automation actions are based on filters to select the entities to Unlink, for instance the “Unlink entity” action. However, weirdly enough, you cannot use a Formula to fill the filter value. So for instance, if I want to unlink an entity by matching its name with a field from the triggering entity, I cannot do it. It is even more frustrating knowing you can link or add an entity using Formulas. ---
**Author:** ![Tommy\_Hedley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tommy_hedley/32/6468_2.png) [@Tommy\_Hedley](https://community.fibery.io/u/Tommy_Hedley)\ **Post date:** [December 30, 2022, 11:27pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/2 "2022-12-30T23:27:47Z")
I would love to see this as well, it would be really helpful for breaking loops when using automations to update certain fields. Also, this should probably be merged with: [https://community.fibery.io/t/formulas-in-trigger-filters/3730](https://community.fibery.io/t/formulas-in-trigger-filters/3730) ---
**Author:** ![rothnic](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/rothnic/32/1850_2.png) [@rothnic](https://community.fibery.io/u/rothnic)\ **Post date:** [December 19, 2022, 8:06pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/3 "2022-12-19T20:06:10Z")
I have been working on layering on automations to the [Template for date grouping](https://community.fibery.io/t/template-for-date-grouping/2678) to serve as meeting some of the functionality described in [More Flexible Board Columns/Rows](https://community.fibery.io/t/more-flexible-board-columns-rows/1321). Some updates on the [Formulas in Views Filters](https://community.fibery.io/t/formulas-in-views-filters/2133) thread reminded me I should submit this request. One thing I came across a few times is that I needed to add some conditions to each of the table schemas so that I could check for special conditions where I wanted to actually apply the action. Since the condition I was looking for was more about automation than the data model, I think it would be better to just implement it as a formula if it isn’t needed elsewhere. ---
**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\ **Post date:** [June 22, 2023, 11:14am UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/4 "2023-06-22T11:14:52Z")
Hi team (@Polina_Zenevich, @Chr1sG), Are there any plans to add this? 🙂 I’m using Fibery’s work tracking with `Day Out` and `Day In` (renamed them so that the database abbreviation is not twice `DO`) and I would like to automatically send messages to Slack. Your demo does a nice job posting in the morning if somebody is off, or if it is a public holiday. But, what I would like to do is post: 1. On Monday morning, who is in on what days of the week 2. At the beginning of a (2–3 week) sprint, if there are public holidays and who is off which days. The current filter options with dates are limited for this purpose as you can see: ![2023-06-22 at 18.52](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/beec299506a4ac36a75239417958c8751f515828.png) Because of course I want to check for dates within the next week. Which is not “one week from now” but “today or up to 5 days from now” or similar for my sprint. Hence a more formulaic filter would be needed. Ideally, I would want to be able to use a formula for a filter to do whatever logic I need to tally what to post. Bonus: Ideally I would want to schedule this automation across different databases in order to compile one single post. I think I already mentioned somewhere that I would love to be able to have a pure automation space (i.e. personal or settings space) where I can configure these kind of database-spanning automations. Thanks a lot! ❤ ---
**Author:** ![Jonathan1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jonathan1/32/10038_2.png) [@Jonathan1](https://community.fibery.io/u/Jonathan1)\ **Post date:** [November 8, 2024, 4:38pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/5 "2024-11-08T16:38:13Z")
A must have, I’m currently facing this limitation. ---
**Author:** ![Michael\_Ichter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michael_ichter/32/9931_2.png) [@Michael\_Ichter](https://community.fibery.io/u/Michael_Ichter)\ **Post date:** [November 20, 2024, 8:23am UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/6 "2024-11-20T08:23:07Z")
Does the “is within” filter option help solve your need? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/60c8512bbdedd9aa2c0e93bd2657469193f9a3b4.png) ---
**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\ **Post date:** [November 20, 2024, 9:16am UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/7 "2024-11-20T09:16:58Z")
Thanks, @Michael_Ichter. “Is Within” indeed solves part of the problem. However the second part is that then it’s a choice of “week” or “month” but I might need 2 weeks (or 3 weeks for those that have 3 week sprints), etc. So overall, I still think the ability to use formulae would be great! 🙂 ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [August 19, 2025, 8:12pm UTC](https://community.fibery.io/t/to-be-able-to-use-formula-in-automation-filters/3706/8 "2025-08-19T20:12:33Z")
Bumping into this limitation too. Use case is for it to set a task to be done when something is done, but it needs to only set it to done if the assignee is the person who triggered the rule. I think this is quite a simple need, but needs the fomula in the filters for the “Update Linked Entities”.