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.
I have existing sheets, reports and dashboards I would like to rename. I am going into the sheet etc. selecting file, rename, renaming and then clicking out of the name box. it appears to have worked. However, when I go back to browse the file reverted back to the previous name. I'm not sure what I am doing wrong.
This discussion was created from comments split from: Workaround for Grouped Reports with multi-select dropdowns.
Good afternoon, Somehow I deleted an entire smart sheet of information. I went into the activity log and I was able to take a snapshot, but now Smartsheet is not letting me import the new information in the smart sheet
