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.
Convert gannt chart into monthly revenue forecast
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.
Comments
-
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.
