# Construct Formula Field Reference from Strings

**URL:** <https://community.fibery.io/t/construct-formula-field-reference-from-strings/2598>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [March 1, 2022, 3:57am UTC](https://community.fibery.io/t/construct-formula-field-reference-from-strings/2598 "2022-03-01T03:57:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Post date:** [March 1, 2022, 3:57am UTC](https://community.fibery.io/t/construct-formula-field-reference-from-strings/2598/1 "2022-03-01T03:57:22Z")

</div>

I am not sure if this is possible, given how formulas are setup in Fibery, however, I thought that it might be quite interesting if it was possible to construct a field reference in formulas using a combination of static text and values from other fields.

The first thing that came to my mind was the [INDIRECT function](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261) from excel which lets users construct a reference to a cell from a string, and then excel actually converts this to a reference to the cell.

So instead of having a formula like this:

```auto
[Project Meeting].Name

```

It would be possible to use a value from a single select field (let’s call it Type) to build the relation:

```auto
Indirect([Type].Name + " Meeting").Name

```

From little I know about the formula implementation and the fact that returning objects are checked by the formula editor, I would assume this to be impossible, but I thought I ask!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 1, 2022, 7:34am UTC](https://community.fibery.io/t/construct-formula-field-reference-from-strings/2598/2 "2022-03-01T07:34:12Z")

</div>

It’s not currently possible in formulas for fields, but it is possible in formulas used in automation actions.  
See here for info on ‘entity queries’

> [@CHANGELOG: Dec 2 / Entity finder for automation formulas, Prevent infinite loops in formulas](https://community.fibery.io/t/changelog-dec-2-entity-finder-for-automation-formulas-prevent-infinite-loops-in-formulas/2288):
>
> eyes Entity query finder for automation formulas Now you can use queries to find entities from any database in automation rules or action buttons. It is very useful when the value should be set dynamically. For example, current sprint or next sprint can be found and set for a user story sprint field. For example, you can move all open stories to the next sprint with a single click: This query finds the next sprint: Sprints.Filter((Dates.Start() \> Today()) and ([Step 1 Sprint].Da…