# Formulas and Projects help!

**URL:** <https://forum.asana.com/t/formulas-and-projects-help/1145863>\
**Category:** Ask the Community\
**Tags:** portfolios, custom-fields, projects, subtasks, agentic-work-management, tasks, rules\
**Created:** [June 23, 2026, 2:20pm UTC](https://forum.asana.com/t/formulas-and-projects-help/1145863 "2026-06-23T14:20:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jenni\_Dent](https://luna1.co/8d76cd.png) [@Jenni\_Dent](https://forum.asana.com/u/Jenni_Dent)\
**Post date:** [June 23, 2026, 2:20pm UTC](https://forum.asana.com/t/formulas-and-projects-help/1145863/1 "2026-06-23T14:20:24Z")

</div>

Hello!

I am attempting to pull a total sum of numbers associated with each of these tasks as a grand total from one project into another.

e.g. the values in the 6th field (3,400 and 250) equal to £3,650 which I then want to pull into a grand total column in a tracker.

 ![image](https://us1.discourse-cdn.com/asana/original/4X/c/6/3/c639b512a17468a7dd5c233e5678c233284f6ae1.png)

![image](https://us1.discourse-cdn.com/asana/original/4X/f/8/f/f8f2ef29903b4bde70fab613acd44f7871838f7a.png)

 ![image](https://us1.discourse-cdn.com/asana/original/4X/9/6/f/96fb93a968f27ee00ca77388f91f9e0e0397444e.png)

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [June 24, 2026, 3:38am UTC](https://forum.asana.com/t/formulas-and-projects-help/1145863/2 "2026-06-24T03:38:37Z")

</div>

Welcome, @Jenni_Dent,

I don’t think you can easily just get the sum alone to appear in another project.

Other ideas as workarounds:

You could get the sum to appear in a Universal Dashboard chart (if on Advanced or above plan, I believe).

Or you could “roll up” the sum into a portfolio that the project is contained in.

You could multi-home (add to project) the set of tasks to be summed into a section in the other project such that the sum, along with the tasks, would appear there as well.

Thanks,

Larry

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\
**Post date:** [July 24, 2026, 3:39am UTC](https://forum.asana.com/t/formulas-and-projects-help/1145863/3 "2026-07-24T03:39:10Z")

</div>

Closed on July 24, 2026, 3:39am UTC

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