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.
Is there a way to create a budget template that automatically populates from a data sheet in Smartsh
Our company uses a single source data page that collects all project related information and also the financials. This page will include all completed and in progress jobs for Departments A-Z with no idents on the page (suggested but was pushed back). It would be ideal to create a report and have the new budget template link to the report since it collects new rows added to the data sheet. Is there a way to create a sheet that updates the financials when a new row is added per column? Example: New row added for Department under Column B, cost estimate for In Progress jobs automatically updates for that department on Budget sheet.