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.
Connect
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
1 Answer
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
Related questions
- How can I add two more properties to this progress bar percentage formula?
- How to see Sprint tasks in the Calendar?
- I want to be notified when somebody has moved a card from one status to another in a sprint board. How can I do it?
- add to do to project
- How can I make completed tasks disappear from Notion Calendar?
Without Answer
-
- 13
- 0
- 6 hours ago
-
- 31
- 0
- 3 days ago
-
- 26
- 0
- 3 days ago
-
- 26
- 0
- 3 days ago
-
- 45
- 0
- 6 days ago
-
- 38
- 0
- 6 days ago
-
- 33
- 0
- May 4
-
- 46
- 0
- May 4
- see all
Exclusive for Notion Answers Users
- • Dynamic Calendar Icon | Info | Download
- Add yours here
Recent Activities
fires3as0n asked 6 hours ago
Disable auto-replaceagentsofshield asked 3 days ago
issues with weekly-to do list automationszenpicker asked 3 days ago
How does Notion figure out the correct foreign key…zenpicker asked 3 days ago
Best workflow for creating related page and then u…KeithFuller answered 3 days ago
Where does notion keep my data?