Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Formula help adding multiple totals to a progress bar.

My current progress bar formula is:

divide(prop(“Total 1”), prop(“Target”))

Which works to give me the progress of Total 1 in comparison to the target.

But, I want to add more Totals to be divided by the target. I can’t figure out the formula to do this.

I already have the remaining totals in the database so it is just a case of knowing how to add them into the formula.

Any help would be great!

2votes

polle commented

Please add some context to understand the complete scenario.

How many columns, how it is calculated and what are you expecting as a result.

2votes

Jacko234 commented

I am looking to do a yearly progress tracker for monthly goals. Each month has 5 goals.

So I have a table which has 12 columns, each relating to a different month (Jan - Dec). I then have the total completed for each month in a column and a column for target goals per year (60).

I’m trying to make a progress bar for the whole year but only know how to do it for one month:

divide (prop(“Jan Total”), prop( “Target Goals per year”))

I would like to add my feb - dec totals to the formula, all to be divided by the target goals per year.

1 Answer

1vote

polle Points77470

A simple way to do it can be creating a new column using a Notion formula to sum all the months.

Just add all months like this:

prop("Jan Total") + prop("Feb Total") + prop("Mar Total") + Etc...

Then do the exactly the same you are already doing, but using the complete sum of the months the formula gives you.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect