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.