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.
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a much more advanced project management solution for construction, but I think that Smartsheets could make some additions that would greatly increase it's functionality.
Currently sheets are mostly individual pieces of information with minor links between sheets. What I would like to be able to do is to set up an entire project from the click of a button. Maybe I'm asking too much but I think the Smartsheets team could do it.
- Be able to link multiple templates to an entire project. e.g. in construction we would have a main sheet with all general information for a project, timeline, estimates, resource allocation, etc
- Generate a template automatically based on rules within a sheet or at the click of a button. A new column type could be create for a "smart button", which could create advanced functions like generating a new sheet off of a template based on the information within the row.
- Generate lists that are syncable across sheets. This would help with resource, personel and budget allocations. Currently dropdown menus are specific to each sheet and can not be linked across sheets. I can't find a way to effectively allocate resources across multiple projects.