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.
Sales Template Help
Options
I’m using template, “Sales Pipeline by Rep”. Instead of using Rep name as the main category, I would like to use the Account/Company name. This way I can sort opportunities by the customer name.
- I would like the total sum values to still sort by category (which is now customer), but filtered by status. Only the items with green status will be calculated Estimated Value & Weighted Value. Is that possible?
- For an excel report, I want to group the lines together by category (which is now customer). So the report will be filtered by customer, than selecting desired status fields. The report should separate each category by an additional row. The additional row should calculate Estimated Value & Weighted Value of all lines in that category.
Comments
-
This is the calculation I believe you are looking for.
=SUMIF(CHILDREN(Status4), @cell = "Green", CHILDREN())
-
Because you're intereseted at lookin at opportunities by Customer name, you might also want to try out Card View (if you haven't already done so). You'd need to capture Account/Company name using a Dropdown column.
You'll find more on Card View here:
https://help.smartsheet.com/articles/2302238-using-card-view-to-visualize-your-project
This discussion has been closed.
