Skip to Main Content
Coming Soon: On April 2nd, all Suggestion Boxes will be migrating to The Network, Trimble's online user community. Your posts, votes, comments, and user accounts will transfer. This site will become read-only after the migration, and this banner will have a link to the new location for ProjectSight suggestions.
Created by Mercedes Green
Created on Apr 11, 2023

Exported Budget Screen should include Forecast Cost and Over/Under formulas

Since the Forecast To Complete, dates and allocation types are editable when exporting the budget, I assume it's used so we can enter our forecasts. When we start entering the forecast to complete costs, it should mimic in the spreadsheet as it does in the budget screen (ie the calculations for Forecast Cost and Forecast Over/Under should change as we type). If they don't' change, it's not really useful as a forecast worksheet that we'll eventually import.


Since the Forecast Cost does not change on the spreadsheet, we can't really use it. We'd have to hide the existing blue columns, then add our own column with new formulas (while trying to figure out what the exact formula should be) then delete before we update back into ProjectSight.


Since the columns are blue and locked anyway, the formulas should be exported and locked as well.

  • Attach files