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

1vote

I have this formula:

round((100 * (((toNumber(prop("Rendered"))) + (toNumber(prop("Approved")))) + (toNumber(prop("Ordered"))))) / 3) / 100

Rendered, Approved, and Ordered are checkbox columns and as I check them off this formula shows a progress bar.

I want to add two more checkmark columns "Delivered" & "Installed" and replace 3 with 5 but every time I try to add them the formula does not work and I think it's because of the brackets. I'm confused about which brackets or parentheses belong to what.

1 Answer

0vote

polle Points79930

Using the structure as you have it, try this formula.

(toNumber(prop("Rendered")) + toNumber(prop("Approved")) + toNumber(prop("Ordered")) + toNumber(prop("Delivered")) + toNumber(prop("Installed"))) / 5

And then just edit your Formula property and select percent.

That will work as you need and will let you add or remove new properties without any problems.

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