Help between Notion users

It's free & easy

Receive points, vote and give the solution

1vote

# emoji progress bar won't increase gradually

Unlike everyone else, in my progress bar, the emojis go straight from the 0% emojis to 100%.

This is my current formula

``substring("♥♥♥♥♥♥♥♥♥♥", 0, floor(prop("Savings Progress")*10)) + substring("♡♡♡♡♡♡♡♡♡♡", 0, 10 - floor(prop("Savings Progress")*10)) + " " + format(round(prop("Actual Saved")/prop("Goal Amount")*100)) + "%" ``

It just does this

``````♥♥♥♥♥♥♥♥♥♥ 175%
♡♡♡♡♡♡♡♡♡♡ 0%
♥♥♥♥♥♥♥♥♥♥ 2%``````

0vote

### polle commented Oct 19

What do you have in the properties Savings Progress, Actual Saved and Goal Amount?

Numbers? Which numbers? Is there a range? Checkboxes?

Please explain the complete scenario to know where the problem may be.

0vote

### esther5 commented Oct 19

of course! i tried attaching images but it didnt work so

Savings progress is a formula in progress bar format formula being = round(prop("Actual Saved")/prop("Goal Amount")*100)

actual saved is a roundup from elsewhere (a number manually inputted into a different table) with a number in it, amount of pounds

goal amount is a number in pounds, maunually inputted

0vote

### polle commented Oct 19

Maybe it is easier if you create a copy and share the Notion link to duplicate it and test there. Without seeing everything it is difficult to catch the problem.

0vote

0vote

### polle commented Oct 19

Please activate the share it to web option and allow duplication.

0vote

### esther5 commented Oct 19

0vote

polle Points68560

For what I can understand after trying to redo the template as it has some missing relations, your result it is correct.

Goal to save: 200
Actual Savings: 250

So the progress marks 100% when you meet the goal, meaning, when actual savings it is equal to goal to save, that is 100%.

But, when you exceed the goal it goes up and that is correct, because 200 is 100% and 250 is 125%, because you are exceeding the 100%. As actual savings is over the goal, then the result is correct.

You will have to rethink the structure as it is not clear what you are trying to do.

Progress bars "with limits" can work as you need, for example a list of tasks, when all of them are completed, that is 100% and the result will always meet that rule, you can't have tasks over 100%, because all of them create the 100%.

But if there are no limits and you just sum and sum and sum, then you can end up with 900% if you actual savings have that amount, there is no limit to go over the goal and that is the problem you are facing.

0vote

### esther5 commented Oct 20

Yeah so theoretically when i have £50 in actual saved and £500 in the goal amount, thats 10% so the bar should look like this ♥♡♡♡♡♡♡♡♡♡ 10%.
But it doesnt it looks like this ♥♥♥♥♥♥♥♥♥♥ 10%

Can you fix this?

0vote

### polle commented Oct 20

Sure, try this Notion formula.

``substring("♥♥♥♥♥♥♥♥♥♥", 0, floor(10 * prop("Actual Saved") / prop("Goal Amount"))) + "" + substring("♡♡♡♡♡♡♡♡♡♡", 0, 10 - floor(10 * prop("Actual Saved") / prop("Goal Amount"))) + " " + format(floor(100 * prop("Actual Saved") / prop("Goal Amount"))) + "%"``

But keep in mind the percentage will never stop increasing when the Actual Saved is exceeding the goal.

1vote

### esther5 commented Oct 20

excellent thank you, thats fine!

0vote

...