Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Function Help
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?
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I am using Smartsheets to gather data and send out mass messages. How do I send out sheets to a mass group without just texting out the link? Is there a easy way to send out forms via SMS and Email? I…
- I have a sheet and the primary column cells are hyperlinked to specific SharePoint documents. It works well for use with Dynamic View, etc. However, when trying to sort by this column it sorts by the …
- I have a form with a question that has three restricted dropdown values. I only want 2 of those values to show on the form but on the sheet it populates to, I want a third restricted option available …
