# \#formulas **URL:** https://community.fibery.io/tag/formulas/24.md [Latest](https://community.fibery.io/latest.md) · [Categories](https://community.fibery.io/categories.md) · [Tags](https://community.fibery.io/tags.md) --- ## ["Contains" formula function](https://community.fibery.io/t/contains-formula-function/10178)
**Author:** [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Replies:** 4\ **Last updated:** [September 8, 2026, 5:25pm UTC](https://community.fibery.io/t/contains-formula-function/10178 "2026-09-08T17:25:07Z")
For comparing strings, as well as comparing a collection and a single entity. Does entity x exist in collection y. Possible with the workaround “Find()” function, but a lot less clean. --- ## [Allow "Now" in formulas, but calculate every minute to save costs](https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644)
**Author:** [@Uladzislau](https://community.fibery.io/u/Uladzislau)\ **Replies:** 13\ **Last updated:** [August 8, 2026, 4:07pm UTC](https://community.fibery.io/t/allow-now-in-formulas-but-calculate-every-minute-to-save-costs/9644 "2026-08-08T16:07:16Z")
Hello. As I see, there are both Now and Today functions available in the automation rules context, while field formulas have only the latter, is that behavior intentional? I’d like to get the current date and time to b… --- ## [Video tutorial on formulas](https://community.fibery.io/t/video-tutorial-on-formulas/11058)
**Author:** [@dmytro](https://community.fibery.io/u/dmytro)\ **Replies:** 0\ **Last updated:** [July 10, 2026, 1:39pm UTC](https://community.fibery.io/t/video-tutorial-on-formulas/11058 "2026-07-10T13:39:38Z")
Hi everybody. Just posted the latest video tutorial about formulas. Like reading more than watching? Here is the text guide instead. Here is what it covers: ⬩ Lookups and rollups: most common formulas … --- ## [Convert text to number or date with formulas](https://community.fibery.io/t/convert-text-to-number-or-date-with-formulas/2375)
**Author:** [@DioniGR27](https://community.fibery.io/u/DioniGR27)\ **Replies:** 23\ **Last updated:** [June 12, 2026, 3:42am UTC](https://community.fibery.io/t/convert-text-to-number-or-date-with-formulas/2375 "2026-06-12T03:42:37Z")
Hi, I think Fibery should let users convert a text to a number or date, using formulas. I have a Period type, which I named as ‘Q’ + Quarter + ‘-’ + Year: I.E: Q1-2022, for referring to the First Quarter of 2022. If I… --- ## ["Union" function to merge multiple collections into a single collections field](https://community.fibery.io/t/union-function-to-merge-multiple-collections-into-a-single-collections-field/5680)
**Author:** [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Replies:** 6\ **Last updated:** [April 21, 2026, 5:34am UTC](https://community.fibery.io/t/union-function-to-merge-multiple-collections-into-a-single-collections-field/5680 "2026-04-21T05:34:09Z")
I’ve seen this pop in many different threads but don’t think there’s an official feature request for it. I’d basically like the same functionality of “Join()” only it returns a collection of entities instead of a text f… --- ## [\[Logic\] Formulas - Chained/Multi-Hop \*-to-Many Relation Fields with Distinct() Function](https://community.fibery.io/t/logic-formulas-chained-multi-hop-to-many-relation-fields-with-distinct-function/10730)
**Author:** [@Sev](https://community.fibery.io/u/Sev)\ **Replies:** 6\ **Last updated:** [April 16, 2026, 3:23pm UTC](https://community.fibery.io/t/logic-formulas-chained-multi-hop-to-many-relation-fields-with-distinct-function/10730 "2026-04-16T15:23:54Z")
Add a Distinct() or Unique() collection function to formulas to return only unique entities from an entity collection, i.e. \*-to-many relation field. While direct relation fields are already unique, duplicates can appea… --- ## [For "hide entity view rule" - allow relation "contains/does not contain" on formula fields](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512)
**Author:** [@Michael\_Ichter](https://community.fibery.io/u/Michael_Ichter)\ **Replies:** 3\ **Last updated:** [March 12, 2026, 1:33pm UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512 "2026-03-12T13:33:29Z")
I’m loving the “hide entity view rule” feature! It’s been a great QoL improvement for us. I’m just facing one limitation. I’m trying to hide a couple entity views based off of users’ membership in departments. Users can … --- ## [Allow to return an empty value from a formula](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983)
**Author:** [@evyatar\_gefen](https://community.fibery.io/u/evyatar_gefen)\ **Replies:** 26\ **Last updated:** [March 10, 2026, 1:36am UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983 "2026-03-10T01:36:38Z")
Sometimes, when using a formula field that returns a single entity, the user might want to return an empty value (meaning no entity). For example, if (X is true return entity Y, else return nothing) There is a workarou… --- ## [Length() Formulas](https://community.fibery.io/t/length-formulas/644)
**Author:** [@helloitse](https://community.fibery.io/u/helloitse)\ **Replies:** 3\ **Last updated:** [February 26, 2026, 3:01pm UTC](https://community.fibery.io/t/length-formulas/644 "2026-02-26T15:01:23Z")
I’d love to create fields that count the number of characters and words in a rich text field. This could be used in a content app to manage social media posts, ad copy, or to draft long form content. --- ## [UX: Formula Field Comments](https://community.fibery.io/t/ux-formula-field-comments/9889)
**Author:** [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Replies:** 2\ **Last updated:** [February 24, 2026, 4:35pm UTC](https://community.fibery.io/t/ux-formula-field-comments/9889 "2026-02-24T16:35:04Z")
Formulas can become rather complex and kicking mind, especially over time. Just as with code practices, it would be very helpful having comments, at least 1-liners, in the formulas, especially between the lines. --- ## [BUG: MatchRegex() "\\b" doesn't work](https://community.fibery.io/t/bug-matchregex-b-doesnt-work/4032)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 6\ **Last updated:** [February 20, 2026, 5:13pm UTC](https://community.fibery.io/t/bug-matchregex-b-doesnt-work/4032 "2026-02-20T17:13:26Z")
In a Formula field, a regex with \\b never matches anything. The above Formula should match these entities, but doesn’t match any: --- ## [Add Modulo and Random operators in Formulas](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 9\ **Last updated:** [February 19, 2026, 7:02pm UTC](https://community.fibery.io/t/add-modulo-and-random-operators-in-formulas/5202 "2026-02-19T19:02:14Z")
Modulo and Random operator in Formulas would be very useful to me! :grinning: --- ## [Allow Formulas to return a collection of just a specific field from Filter results](https://community.fibery.io/t/allow-formulas-to-return-a-collection-of-just-a-specific-field-from-filter-results/5658)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 3\ **Last updated:** [October 22, 2025, 2:09pm UTC](https://community.fibery.io/t/allow-formulas-to-return-a-collection-of-just-a-specific-field-from-filter-results/5658 "2025-10-22T14:09:27Z")
I have a Collection of “Roles”, where each Role is related to a User. I want to create a Formula field that returns the collection of all the Users linked to the Roles in the collection. But it’s not currently possible… --- ## [Variables in formulas](https://community.fibery.io/t/variables-in-formulas/1277)
**Author:** [@tpaktop](https://community.fibery.io/u/tpaktop)\ **Replies:** 4\ **Last updated:** [October 21, 2025, 11:41am UTC](https://community.fibery.io/t/variables-in-formulas/1277 "2025-10-21T11:41:23Z")
Hi, I have been writing some quite advanced formulas in Fibery: I found that after some time even I cannot figure out what the heck formula does as it’s all in one gigantic expression. Would it be possible to add s… --- ## [Additional Formulas functions](https://community.fibery.io/t/additional-formulas-functions/8351)
**Author:** [@Alex\_Rublev](https://community.fibery.io/u/Alex_Rublev)\ **Replies:** 1\ **Last updated:** [October 15, 2025, 6:52pm UTC](https://community.fibery.io/t/additional-formulas-functions/8351 "2025-10-15T18:52:21Z")
I think many have encountered situations where certain formulas functions are missing, so I would like to kindly request an expansion of the functionality. For example: ToDays() workdays A flag or separate formulas to … --- ## [Formula field: Custom formatting to the dates](https://community.fibery.io/t/formula-field-custom-formatting-to-the-dates/9619)
**Author:** [@myg\_ge](https://community.fibery.io/u/myg_ge)\ **Replies:** 0\ **Last updated:** [September 18, 2025, 5:25pm UTC](https://community.fibery.io/t/formula-field-custom-formatting-to-the-dates/9619 "2025-09-18T17:25:48Z")
Looks like there’s no an easy way to format the date (eg, DateFormat()) at minimum like so YYYYMMDD (20250901) with leading zeros (not the only case). I know I could use stuff like “Left() and Right()”. But it takes thr… --- ## [Can't output literal newlines from Text formulas](https://community.fibery.io/t/cant-output-literal-newlines-from-text-formulas/3316)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 4\ **Last updated:** [August 31, 2025, 1:50pm UTC](https://community.fibery.io/t/cant-output-literal-newlines-from-text-formulas/3316 "2025-08-31T13:50:09Z")
Seems like this should just work: --- ## [Formula to return the alphabet letter based on the number](https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471)
**Author:** [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Replies:** 1\ **Last updated:** [August 26, 2025, 8:26pm UTC](https://community.fibery.io/t/formula-to-return-the-alphabet-letter-based-on-the-number/9471 "2025-08-26T20:26:36Z")
Input: 1, Output: a. Input: 20, Output: t Input: 27: Output aa etc. Useful when using version coding. its nicer to see 1a and 1b rather then 1-1 and 1-2. Can be done manually, but results in big formula. --- ## [New entities are not automatically linked using their creation context if they are related via an auto-link Rule](https://community.fibery.io/t/new-entities-are-not-automatically-linked-using-their-creation-context-if-they-are-related-via-an-auto-link-rule/5561)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 8\ **Last updated:** [August 21, 2025, 7:57am UTC](https://community.fibery.io/t/new-entities-are-not-automatically-linked-using-their-creation-context-if-they-are-related-via-an-auto-link-rule/5561 "2025-08-21T07:57:39Z")
Consider two DBs, Parent and Child: Parent DB has a \[Children\] collection of Child entities A Child has only one Parent, and it has a \[Parent Id\] field for specifying its Parent The relation uses an auto-link Rule: Chi… --- ## [Formula 'Generate using AI' keeps on using 'null'](https://community.fibery.io/t/formula-generate-using-ai-keeps-on-using-null/9314)
**Author:** [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\ **Replies:** 1\ **Last updated:** [August 1, 2025, 10:44am UTC](https://community.fibery.io/t/formula-generate-using-ai-keeps-on-using-null/9314 "2025-08-01T10:44:10Z")
Fibery’s formulas can’t use ‘null’ but the ‘Generate using AI’ still keeps on suggesting formulas that use ‘null’ --- ## [Set required field by formula / automation](https://community.fibery.io/t/set-required-field-by-formula-automation/8664)
**Author:** [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Replies:** 0\ **Last updated:** [April 25, 2025, 8:33pm UTC](https://community.fibery.io/t/set-required-field-by-formula-automation/8664 "2025-04-25T20:33:53Z")
I have a situation where I want to set the field of the “Stage” by automation. Where it takes the first stage from the selected pipeline. Hence, it should not be set on creation, the automation sets it. But after this, i… --- ## [Sanitize text for formulas (all caps/lower case/strip punctuation, etc.)](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510)
**Author:** [@CivicScribe88](https://community.fibery.io/u/CivicScribe88)\ **Replies:** 3\ **Last updated:** [March 28, 2025, 10:22am UTC](https://community.fibery.io/t/sanitize-text-for-formulas-all-caps-lower-case-strip-punctuation-etc/8510 "2025-03-28T10:22:13Z")
I searched for this, but couldn’t find any details about basically sanitizing text so I can compare text in one field to another. In my current case, I want to copy and paste language from a government database (the leg… --- ## [Split Function for Formula](https://community.fibery.io/t/split-function-for-formula/4686)
**Author:** [@njyo](https://community.fibery.io/u/njyo)\ **Replies:** 19\ **Last updated:** [March 5, 2025, 4:06pm UTC](https://community.fibery.io/t/split-function-for-formula/4686 "2025-03-05T16:06:40Z")
Hi, when formatting text I want to ensure Capital Case (i.e. each word capitalised) for example with names in a text field. While there are Upper(), Lower(), Find(), Trim() and ReplaceRegex() functions, there its no Spli… --- ## [\[DONE\] Months() and Years() function in formula](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620)
**Author:** [@Jonathan1](https://community.fibery.io/u/Jonathan1)\ **Replies:** 5\ **Last updated:** [January 9, 2025, 3:53pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620 "2025-01-09T15:53:37Z")
Will it be possible to add Months() and Years() function in formulas ? The idea is to be able to add or remove X months or X years from a date (as we currently can do with Days() function). --- ## [\[DONE\] Week number formulas](https://community.fibery.io/t/done-week-number-formulas/3880)
**Author:** [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Replies:** 10\ **Last updated:** [January 9, 2025, 3:29pm UTC](https://community.fibery.io/t/done-week-number-formulas/3880 "2025-01-09T15:29:16Z")
UPDATE: improved formulas below. UPDATE 2: native week number function is now available. After a couple of people asked about calculating week numbers for a given date, I thought I’d share these two formulas that you m… --- ## [Rich Text field from a Formula](https://community.fibery.io/t/rich-text-field-from-a-formula/5223)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 4\ **Last updated:** [January 1, 2025, 6:16pm UTC](https://community.fibery.io/t/rich-text-field-from-a-formula/5223 "2025-01-01T18:16:51Z")
Right now you cannot choose “Rich Text” as the Type of a Formula field :frowning\_face: But why not? Underlying Rich Text content is just text (markdown/HTML/JSON). There are interesting possibilities here, like: Auto… --- ## [Formula to assign number based on sorting](https://community.fibery.io/t/formula-to-assign-number-based-on-sorting/3652)
**Author:** [@Eren\_Turgut](https://community.fibery.io/u/Eren_Turgut)\ **Replies:** 4\ **Last updated:** [September 6, 2024, 12:49pm UTC](https://community.fibery.io/t/formula-to-assign-number-based-on-sorting/3652 "2024-09-06T12:49:58Z")
Hi everyone :slight\_smile: Not sure if this is a help request or a formula function request: Is there an elegant way to number up entities in a formula field based on a sorting? If this is not possible, I’d like to req… --- ## [Allow Rules/Formula Involving Rich-Text Fields](https://community.fibery.io/t/allow-rules-formula-involving-rich-text-fields/2108)
**Author:** [@v3j](https://community.fibery.io/u/v3j)\ **Replies:** 25\ **Last updated:** [December 12, 2024, 4:59pm UTC](https://community.fibery.io/t/allow-rules-formula-involving-rich-text-fields/2108 "2024-12-12T16:59:07Z")
Is this possible? #1 (Rule): If a rich-text field is not empty, then a checkbox’s value becomes ‘True’ #2 (Rule): If a rich-text field is not empty, copy the first few words to a text field Use-case: I just want to k… --- ## [For external integrations like Relay.app, allow retrieving Workspace queue status](https://community.fibery.io/t/for-external-integrations-like-relay-app-allow-retrieving-workspace-queue-status/6671)
**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Replies:** 0\ **Last updated:** [September 19, 2024, 1:13pm UTC](https://community.fibery.io/t/for-external-integrations-like-relay-app-allow-retrieving-workspace-queue-status/6671 "2024-09-19T13:13:51Z")
My apologies if this is already implemented – but in case it is not, this would be an important feature to me for external tool integrations like Relay.app: Allow external tools to easily monitor the status of Fibery Wo… --- ## [\[DONE\] Allow for making formulas multi-line in formula editor](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477)
**Author:** [@Dimitri\_S](https://community.fibery.io/u/Dimitri_S)\ **Replies:** 4\ **Last updated:** [July 4, 2024, 12:51pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477 "2024-07-04T12:51:14Z")
Using Google Sheets as an example you can do this via Alt + Enter and it allows for easier viewing and editing of nested formulas: In Fibery it would be really nice if I could restructure this dense single line formul… [Next page](https://community.fibery.io/tag/formulas/24.md?match_all_tags=true&page=1&tags%5B%5D=formulas)