# Alternative to parentRow in formula?

**URL:** <https://connect.superhuman.com/t/alternative-to-parentrow-in-formula/55774>\
**Category:** Ask the Community\
**Created:** [May 21, 2025, 7:24pm UTC](https://connect.superhuman.com/t/alternative-to-parentrow-in-formula/55774 "2025-05-21T19:24:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Balint\_Drahota](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/balint_drahota/32/10969_2.png) [@Balint\_Drahota](https://connect.superhuman.com/u/Balint_Drahota)\
**Post date:** [May 21, 2025, 7:24pm UTC](https://connect.superhuman.com/t/alternative-to-parentrow-in-formula/55774/1 "2025-05-21T19:24:30Z")

</div>

Our use case needs an alternative to [the depreciated parentRow formula.](https://help.coda.io/en/articles/5979455-canvas-column-type#h_f9b83619f0) Think of it like we have Ingredients, Dishes and Orders table, and need to multiply Ingredient quantities with the different Ordered Amount of each Dish. Tried with table reference column type and many others but.. can you please come up with a solution?

---

<div class="post-metadata">

**Author:** ![Melanie\_Teh](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/melanie_teh/32/45501_2.png) [@Melanie\_Teh](https://connect.superhuman.com/u/Melanie_Teh)\
**Post date:** [May 21, 2025, 7:43pm UTC](https://connect.superhuman.com/t/alternative-to-parentrow-in-formula/55774/2 "2025-05-21T19:43:22Z")

</div>

👋 @Balint_Drahota

i think what youre describing is a BOM (Bill of Materials) setup.

below is a link to a template that @Connor_McCormick1 has kindly shared a solution to 🙂

> [@Inventory System Template | Item Schema | BOM](https://connect.superhuman.com/t/inventory-system-template-item-schema-bom/25231):
>
> Hi Community, Here’s another doc I wanted to share with you! I’ve built many inventory systems for my own company and for other people, and I frequently ran into complications. Finally, I think I’ve found a pattern that makes for a great starting point, so I wanted to share my inventory superpowers with the community slight_smile Reach for this template whenever you need to keep track of items that contain sub-items. Here’s a loom that gives you an intro to the doc: [Intro to Item Schema…](https://www.loom.com/share/a5fd8e2ee7334a8e9d9bc7af49983a5a)

hope this helps!

Cheers!  
Mel

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [August 19, 2025, 7:43pm UTC](https://connect.superhuman.com/t/alternative-to-parentrow-in-formula/55774/3 "2025-08-19T19:43:47Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.