To show the combined value of approved purchase requests from different sheets, how should Bobbi proceed?

Creating a report to combine approved requests and summarizing the values using the SUM function is an effective approach for showing the combined value of approved purchase requests from different sheets. This method allows Bobbi to pull in relevant data from multiple sheets into a single report, ensuring that all approved requests are displayed in one place.

Once the report is generated, using the SUM function enables Bobbi to efficiently calculate the total value of those requests. This approach not only consolidates the information but also provides a clear and straightforward overview of the financial implications of the approved purchase requests. The ability to combine data sources and perform calculations within a report is one of the strong features of Smartsheet, making this option the most strategic and effective.

In contrast, creating individual reports for each category would lead to fragmented information, making it difficult to have a holistic view of the data. Compiling all requests into one sheet before reporting can be cumbersome and may disrupt the workflow by requiring manual input. Finally, while creating a dashboard with widgets for each category can be useful for visualization, it may not directly provide the consolidated value that Bobbi seeks, nor would it facilitate easy calculation of the sum without additional steps. Thus, the most suitable choice is to generate a report that consolid