Question

I have already added the companies I'm connected with as Projects and tasks for those projects. Currently, I can see the number of companies in each category, such as their stage on the sprint board. However, I need to represent these numbers in percentages. For instance, let's say X has made contact with 100 companies, out of which 20 were via Email, 60 via call, and 20 via personal visit. Additionally, 20 out of the 100 companies have moved to a demo stage. To simplify, I have already performed these calculations in Excel, but now I want to know how I can incorporate these google sheet formulas into Notion.

Answer 1

Hi,

so let's say you want to calculate the percentage of companies that have moved to the demo stage out of the total number of companies.

1) Add a new column to your table. Hover over the header row, click '+', name the new column, and select the type as "Formula".
2) In the "Formula" field, you will be able to write your formula.
3) For your specific case, you might want to use a formula like this:

prop("Demo Stage") / prop("Total Companies") * 100

Here, prop("Demo Stage") and prop("Total Companies") are placeholders for your real column names. Replace them with the actual column names in your Notion table.

I hope this is what you were looking for. I not I might need some more details about how exactly you would like the output to look because there are a few options.

Martin