Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Simple percentage
Comments
-
awesome, thanks - now to find out how to only take the sum of parent cells in a column!
-
Tom,
To show the percentage that one number is to another, use this:
=[Actual Revenue]2 / [Target Revenue]2
Change these cells to match yours.
As far as SUMing only parent rows, you could do a couple things:
1. add an indicator (such as a checked box) to each parent row and use that in a SUMIF statement.
2. Add a new parent row, then indent all your other parents under the new parent and use the SUM(CHILDREN() function.
-
I have updated the example sheet to show how to use the SUM(CHILDREN()) function: https://app.smartsheet.com/b/publish?EQBCT=3a04c9f4065b4a18b17b4fec9bb3aef6
For more information about Hierarchy in Forumlas: http://help.smartsheet.com/customer/portal/articles/775363#hierarchy
-
Hi Tom,
The video in help center (http://help.smartsheet.com/customer/portal/articles/775363) is a great place to start, which shows how to use formula. The help also has a link to a formula examples template (Look for " Click here to preview the Formula Examples Template ").
Here's an example I have come up with: https://app.smartsheet.com/b/publish?EQBCT=3a04c9f4065b4a18b17b4fec9bb3aef6
A few points I want to highlight some of the toolbar buttons that you may find useful:
* Use the "$" button to format the revenues columns
* Use the '%" button to format the percent column
* (Optional) Use "<-0.00" button to show more digits on both the revenues and percent columns
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives