Create a SUM line for only 2 of 3 groups on a board

Platform discussions
, ,
1

I have created a 2-year forecast to plan project budgets. Each project or piece of equipment is represented as a row within a group. Each month is represented as a Number Column ($) along with a formula column to SUM the TOTAL cost for the FY.

I’d need to create two rows at the end of the board reflecting the SUM for specified groups.

Example:
Row #1 - SUM of Groups 1, 3, 5
Row #2 - SUM of Groups 2, 4

This would allow me to see how much I have in budget for a specific project vs. Total Budget.

Is there any work around that can help me achieve this?

image
image1445×731 178 KB

2

Hi,

with our app you can do it- take a look

3

@MayBitman thank you. Which recipe would I use? I downloaded the Smart Columns app, but do not see any recipes for adding sum of specified groups.

4

You can use one of these 2 recipes:

You can find more info in the “how to use” section.

Best,

1 Like