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.
Question about tracking project budgets in Smartsheet
Hello all,
I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and categories (BOM cost vs non-BOM which is then broken down into labor, travel, and installation costs).
Do you have any recommendations or examples of either approach that I can look at? Ultimately, I want to create a dashboard for them using Smartsheet Sights so any tips on how to integrate that would be welcome as well.
Thanks!
Monikka
Comments
-
Hello—
Do you need to have your BoM and non-BoM (assuming you mean Bill of Materials) on separate sheets, or just have ways to look at them separately?
You could consider having one sheet with a separate column for every cost type, then have a total column with a SUM formula that sums all of the costs on the row. More on the SUM function here: https://help.smartsheet.com/function/sum
Reports can be created based on specific cost types by pulling in the cost's column, and you could then add a Report Widget to your Sight.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives