Please add a sum product formula to improve ease of calculations without workarounds.
Sign in to see the current vote count, add your own vote, or leave a comment.
All of the examples I have seen regarding SUMPRODUCT can be replaced with a basic SUMIFS. Can you provide some example use cases where workarounds are needed as opposed to some functions that are already built in?
@Paul Newcome Can you show me an example where a sumifs could be used in place? I know we can use helper columns to achieve the end result. Looking for capabilities that do not require workarounds. Something we could also incorporate a hierarchy function as well.
It's kind of hard to explain my situation, but effectively I need a sum prod formula, without using additional helper columns. I did use a workaround. But I feel like the purpose of enhancement requests is to reduce the need for workarounds.
I agree that the purpose of the enhancement request is to reduce the need for workarounds, but I didn't see where a workaround was needed until you presented your use case.
From Microsoft's Website:
A SUMIFS would generate the same result
=SUMIFS(D2:D7, B2:B7, @cell = B@row, C2:C7, @cell = C@row)
Two more examples from the same page:
First one would be SUMIFS + SUMIFS, and second one would be a straight SUMIFS again.
But it looks like in your example you are needing to use weights before summing the hours. I've not used the SUMPRODUCT in Excel before, so I was just going based on what I was seeing on Microsoft's page. Seeing your use case is definitely helpful.
Fair enough. I appreciate your feedback! I've actually never seen a sumproduct used in those examples you shared so that was interesting to see. This example from that page is most in line with what I was trying to achieve in a single formula without helper columns.
And I had never really used SUMPRODUCT before, so I was only able to go off of what I was seeing there. Haha.
Either way... Your use case definitely currently requires a helper column in Smartsheet, so the SUMPRODUCT function would be useful. I just wasn't sure what you were getting at until I saw your use case.
Helpful for EVM calculations
thanks for your calculation
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
