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.
©2022. All Rights Reserved Smartsheet Inc.