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

Michael Acton
edited 12/09/19 in Archived 2017 Posts

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.


This discussion has been closed.