Sales Template Help

L Anderson

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.

1. 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?
3. 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.

JamesR

This is the calculation I believe you are looking for.

=SUMIF(CHILDREN(Status4), @cell = "Green", CHILDREN())

 

 

Gwyneth C

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