# Ad hoc formulas in views

**URL:** <https://community.fibery.io/t/ad-hoc-formulas-in-views/2932>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [June 9, 2022, 7:27pm UTC](https://community.fibery.io/t/ad-hoc-formulas-in-views/2932 "2022-06-09T19:27:35Z")\
**Posts on this page:** 1\
**Showing post:** 19

<div class="post-metadata">

**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 8, 2023, 5:50am UTC](https://community.fibery.io/t/ad-hoc-formulas-in-views/2932/19 "2023-06-08T05:50:55Z")

</div>

I guess I’ve previously indicated that I’m not a big fan of unnecessary (static) Lookup fields because I feel that they clutter my entities unnecessarily.

Hence, I love Formulae and the flexibility and dynamic manipulation possibilities they give. The main place I find them missing at this point are in View Filters.

I’d love to be able to:

- Display only features with “must have” user stories in a given sprint
- Tasks that were completed between three weeks and two weeks ago (a little construed but right now I’m relying on the predefined options)
- Tasks that are in a “final” (or even custom) state

All these things would be possible the moment I can use formulae in Filters. You have most of the pieces already in place and I hope this will be added soon. Just not sure if that’ll impact performance but I would think with GraphQL underneath there should be no impact filtering on the fly?

Thanks!

PS: Not sure, if this is actually a [duplicate of this FRQ](https://community.fibery.io/t/formulas-in-views-filters/2133).

---

_[View the full topic](https://community.fibery.io/t/ad-hoc-formulas-in-views/2932)._