Convert gannt chart into monthly revenue forecast

Michael Acton

I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines.  I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the spreadsheet view look like a regular columnar revenue forecast with revenues by contract and monthly or weekly totals- is this possible and if so, any help would be greatly appreciated.

Shaine Greenwood

Hi Michael,

There currently isn't a way to update information in Smartsheet from MS Project, although you can export and import sheets from MS Project with the steps in the help articles:

Importing Files to Create New Sheets

Exporting Sheets and Reports from Smartsheet

Keep in mind that this is a manual process—as information is updated in Smartsheet, you'll need to export as a new MS Project file.