Looking to filter for unique value and summarize amounts
I am not sure this can be done with Smartsheet. In the screenshot, I need to retrieve unique values in the project# column and summarize the values for each project. The bottom part in yellow shows the result I am looking for.
Any help would be greatly appreciated!