Gantt Chart Revenue Forecasting
I've built a sheet with all of our active projects and am wanting to predict revenue.
I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and more projects in there.
Comments
-
Hi,
You can definitely achieve what you're looking to do, but I need more info about what your data looks like and what you're hoping to achieve.
As a start, you can set the labels for your Gantt to anything you want by changing the Display label for setting in the Project Settings dialogue box.
If you have a Revenue Forecast column, you can use this. If you want to combine data, then create a new column and enter a formula like =Task1 + " - " + [Revenue Forecast]1 to create a more detailed label.
Kind regards,
Chris McKay
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives