Gantt Chart Revenue Forecasting

jruppert
jruppert ✭✭
edited 12/09/19 in Smartsheet Basics

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

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    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

    GanttLabel.png