-
How to include new form links for newly provisioned projects?
Goal: Have links to included forms update to the newly created forms (same as sheets, etc.) when generating a new project folder via control center. I was under the impression that this would be possible once forms became searchable objects in Smartsheet. I tested in a dashboard and 1. Was unable to find forms in the…
-
Link for Templates
We'd like to create a dashboard with reports and various team resources, such as templates. There is not a way to hyperlink, link templates OR add templates to dashboards. This would be extremely helpful. Thank you!
-
Multi-Select Projects to "Update Reporting" in Control Center
Whenever a change is made to a blueprint in control center we are already disadvantaged by only being able to apply this change to future projects created from the blueprint. We can however, using Global Updates retroactively add certain rows to summary sheets that can be a proxy to apply changes to existing projects.…
-
How do I automatically keep "link in from" in the Main Sheet when a new row is added from a Form?
I have the main sheet "Request Tracker with Form" and a separate sheet "Infrastructure-Access and Permissions" where updates automatically occur with a "Request Update Automation" but the reference link within the Access and Permissions-Completed column does not populate in the main sheet automatically, I have to go in and…
-
How to add additional information after a form is submitted?
We use forms to create project requests, and we know each form is submitted and creates a new row in the underlying sheet. We have 6 unique forms tied to one "project type" sheet (x3 project types). The forms are super intricate and logical, and the sheet has a ton of automations and workflows to it. Our executives want to…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
-
On Roadmap to make it easier to grab link to row?
Hi Smartsheet - Is it on your roadmap to make it faster to get the link to a row? I'd like to be able to right click on a row, and select an option that places the link to that row into my clipboard for me. Bonus points for allowing me to get a link to a specific cell or range. Currently to get the link to a row, we have…
-
How to link a column to a different sheet that auto populates when new rows are added?
I'm trying to do a workaround to adding multiple rows from the same form. I created a new sheet that has columns for requests 1-10. I want to pull certain columns from that sheet to move to a new sheet and then I can use a workflow to transfer that to my main sheet. I've created an ID column that autogenerates a number as…
-
How to link only to parent level data in source sheet?
Hello, I am wanting to link cells so that the column in my destination sheet contains only the data in parent-level rows on my source sheet. Right now when I link and highlight the source column, it pulls in the indented levels also. Or it will leave blank spaces in my destination sheet where the source sheet may have…
-
Gantt Chart - linking start / end dates
Im a beginner so bare with me. Im creating a GC where the beginning and end part of the process are irrelevant for the C suite - only interested in hard deadlines and the overall duration of the project minus the grey areas. However, these task rows and durations need to still be included to help manage the work flow for…