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.

Find more posts tagged with

Construction

Reports

Gantt View

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…