Sign in to join the conversation:
How would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?
You can use SUM with COLLECT like this:
=SUM(COLLECT([% of Cost]9:[% of Cost]34, [Assigned To]9:[Assigned To]34, ="Cement Guy"))
" =SUMIFS( " works the same way as " =SUM(COLLECT( "
Just another option to keep in mind.
Hello, I am having trouble making my Dynamic View work. I feel like I am following the instructions but I seem to be the only one able to see the "view". Trying to test this internally before I push out to the customer. I am using a filter that is built into the main worksheet. Anyone have time to review with me? Thank you…
I’m having service provide agreements for different clients, how to implement a e-sign workflow in smart sheet where a document is generated and sent for signature to the clients.
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
