-
Importing certain information from one smartsheet to another
I have created a "Grid" that is being filled in by a form from our team. I wanted to see if there is a way that IF a certain 'column' has the work "Detailed Cleaning" and it is filled with information that it will transfer over to another smartsheet "Grid" so they can focus on just that item. For example, I have a report…
-
Automate Generate Documents
Is there a way to automatically generate documents when a new row is added?
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
Allow Form Submissions Without Granting Access to the Source Sheet?
This discussion was created from comments split from: Sharing form link without providing edit or read-only access to underlying Smartsheet.
-
conditional format
Hello maybe someone knows if it's possible to define condition format by using a formula in condition as it can be done in Excel For ex if I want to define a green color for KPI value if it is more than 95% from the target ' without specifying the additional calculated field
-
Access to Form but NOT Sheet Data
Hi, Quick question, is there a way to provide an internal user access to submit a form but not be able to view/access the Sheet and it's data? We're creating a Write-Off process in Smartsheet and even though we are allowing anyone to submit a request, we only want a certain audience to view the sheet contents. Thanks!
-
Automation Settings Should Be Kept When Saving a Template
Currently, If you update automation settings on a sheet, and then save the sheet as a template, the automation settings do not save. When using the template, all automation settings revery back to 'restricted'. All settings should carry over from the source sheet.
-
My folder view is not dropping down
My folder view is not dropping down on the left hand side- it normally allows me to select the folder on the left side of the pane and see the various project folders including the metadata, schedule etc. However, now when I click on the project folder I only see these project folders center of my screen. Is there a way to…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
-
Toggle Buttons for Entire Dashboard?
I have an dashboard built and want 4 buttons to toggle between different possibilities (1, 2, 3, or 1 2 & 3). Is there a way to do this?
