Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reporting Roll Up
Reporting newbie and need guidance. I have a standard sheet which has an Activity column where the drop down list is Active, Closed, Inactive, Requested, etc.) Each item in the row is tied to a dollar figure. Can Reports pull both columns, but roll up the Activity column by name into a total dollar figure?
i.e. 2 rows under Active are $100K each, 2 rows under Closed are $100K each. Can Report Builder only show 1 row for Active and one for Closed, but show the total $200K value for each?