# Can't create lookup field from related object's formula field **URL:** \ **Category:** Get Help\ **Created:** [November 10, 2023, 8:05am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395 "2023-11-10T08:05:45Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [November 10, 2023, 8:05am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/1 "2023-11-10T08:05:45Z")
I have a formula field in a “Task” object and want to display that field as a lookup on it’s associated “Iteration” object, but it’s not showing up as an option. I’ve double checked that everything’s associated correctly. Is this a bug or is there a lookup limitation I’m unaware of? ---
**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:** [November 10, 2023, 8:09am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/2 "2023-11-10T08:09:22Z")
What is the data type of the result of the formula? Lookups only work for certain field types - you can’t use them for dates, number or text. But you might be able to use a formula instead of a lookup… ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [November 10, 2023, 2:47pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/3 "2023-11-10T14:47:02Z")
It’s a number formula, so that maybe explains it. Your suggestion is to create an new formula that simply displays the value of the other formula? ---
**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:** [November 10, 2023, 2:53pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/4 "2023-11-10T14:53:24Z")
Assuming that there is a to-one relation, then yes, a formula is the right way to show the number value in a related entity. Lookups are typically used when the result is a collection of entities, e.g. if a Project has many Tasks, and each Task has an Owner, you can make a lookup on the Project to get the Owners of all the Tasks. On the other hand, if your Projects have a score, and you want to see it on each of the Tasks, you can just use a formula: `Project.Score` ---
**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:** [November 10, 2023, 2:54pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/5 "2023-11-10T14:54:49Z")
And to add a bit more, if the Tasks each have an Effort value and you want to get the total Effort for a Project, you would use an aggregation function in the formula, e.g. `Tasks.Sum(Effort)` ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [November 10, 2023, 3:03pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/6 "2023-11-10T15:03:36Z")
Thanks. I’ve been thinking of lookups more like “rollups” in ClickUp, where they will automatically sum up all the values below them. Formulas are a little more complex, but I understand now. Here’s what I ended up using: For the Tasks to sum all the “Points” associated them into a field called “Used Points”: If( IsEmpty([Parent Task]) = true, Subtask.Sum(Points) + Subtask.Sum([Used Points]) + Points, Subtask.Sum(Points) ) For the Iteration to sum up all the “Used Points” of the tasks underneath them: Tasks.Sum([Used Points]) I’m slowly getting the hang of things! ---
**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:** [November 10, 2023, 3:26pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/7 "2023-11-10T15:26:46Z")
Note: If the Task db has a one-to-many self-relation to itself, then you can actually write a recursive formula that will sum all the Points of all Subtasks, and grandchild Subtasks, and great-grandchild Subtasks, etc. To do so, just create and save a formula with a constant number output, e.g. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/068ec7e64c57ab2515088a18df6c71d7eacc0bdd.png) and then once this is done, you can edit the formula to refer to itself for related items, e.g. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/301fef84eaa3f9b98b52ea44b397274b486d9d8e.png) ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [November 13, 2023, 3:19am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/8 "2023-11-13T03:19:32Z")
Thanks, your formula works and is cleaner than mine, I just don’t understand in your example why the “Total points” field with the constant is required to make it work and I’d prefer not to have an extra field that only exists to help a formula be a bit simpler. Could you help me understand? Like, this seems to work for me with no constant, but perhaps there’s a scenario where it would break?: If(Subtask.Count() \> 0, Points + Subtask.Sum([Used Points]), Points) ---
**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:** [November 13, 2023, 7:10am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/9 "2023-11-13T07:10:24Z")
> [@interr0bangr](#): > > Thanks, your formula works and is cleaner than mine, I just don’t understand in your example why the “Total points” field with the constant is required to make it work and I’d prefer not to have an extra field that only exists to help a formula be a bit simpler. Perhaps there has been a misunderstanding - there are two fields in my example, and only one of them is a formula field. `Points` is the manually entered value. `Total Points` is the automatically calculated sum of all Points, including subtasks Total Points needs to refer to itself, but it can only be referenced once it exists. The first step (of making and saving a formula field called `Total Points`) is needed so that this is possible. The actual value assigned is irrelevant, since it gets overwritten in step 2. I just chose to make it = 1. All that matters is that there exists a formula field that returns a number value. In your case, it looks like `Used Points` already existed, so updating it to be recursive was immediately possible, but for anyone reading this thread, I figured it’s useful to know the full process. ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [November 13, 2023, 1:57pm UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/10 "2023-11-13T13:57:01Z")
Perfect, sorry for the confusion and thanks for clarifying! ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [April 29, 2025, 1:43am UTC](https://community.fibery.io/t/cant-create-lookup-field-from-related-objects-formula-field/5395/11 "2025-04-29T01:43:09Z")
Agree here with you @interr0bangr …it is too much work for me to create a formula when I’d just like to take the formula already in the related object. My case specifically - feedback related to idea, I have the feedback’s total conversations in a formula. I want to show on the idea how many conversations that feedback has. Would prefer not to get into formulas. Is this something that could be requested, or is there some technical limitation? Read this whole thread and couldn’t determine an answer to this question… Thanks!