-
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…
-
Tracking Activity on Form Links
It would be helpful to have some tracking on how many people are clicking on links for forms/open the form. We have surveys that are sent out to various partners and it would be helpful to know if the form is being looked at or not. Additional tracking could be on who has opened it (if required to log in to complete) or if…
-
Formulaic Help / Cross-Sheet References
Bit of a complex one: Let's say I have a sheet named "Additions To Scanning Workflow" (with a select number of users) that includes 13 columns of data, one column ("Ready for Digitization Dept.") that's a checkbox field. I want the select number of users to be able to fill out this sheet and when the "Ready for…
-
Pre-Filled Form URLs
Hi SS Community, I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not when I click on the link in the Smartsheet table, the last field (Personal Email) is blank. Does this mean that there is an…
-
Is there a way to make the form link clickable in google chat notifications from Smartsheet?
Right now, when I send a reminder to fill out a form with the link, it is not clickable (the smartsheet app is, and the email notification is), but, this is odd as for a while I only had my G-chat notifications on for receiving smartsheet updates/notifications, but had to turn on my emails again in order to receive the…
