-
Dynamic View and Groups
I have a Sheet with sentitive data. I need to share certain rows to Groups of people. Row A, Group Admin SHS can view. Row B, Group Admin BSH can view. Group. Admin BSH should not see Row A. Groups have been created. When I go to the sheet, I can't see the groups to add to a row I assume in Dynmaic view, when these Groups…
-
Adding Users to a Group
I'm trying to build a workflow that will automatically add users to a Smartsheet Group if their email is our company's domain (to make it easier to share WorkApps and some universal workspaces). I've got everything working but the darn HTTP call to add to the group I am using Get Row to pull email addresses from my Users…
-
Control Center - Add Existing Projects to Intake Sheet
Is there a programmatic way of adding existing projects to the Intake Sheet via Control Center or other means without duplicating respective projects? I've been using Control Center to provision projects in my portfolio, but want to add projects which have already been created to the Intake Sheet to promote a unified way…
-
DataMesh Finding Only 5 Unmatched
Hey Folks! I have used DataMesh to create many things in SS all built off the same source sheet. It has been quite some time, but running into an issue lately where the only results are 5 Unmatched (Image attached). Hoping to get some guidance here. The Seq. # is unique to each entry on the Source Sheet.
-
Multiple Contacts in One Field/Filter
Hello, I have a Dynamic View with a filter as follows: In the Email field will be the overall Department Chair and is a column in my source sheet that is constant. In the Division Chief field I want to have the ability to list multiple Chief contacts. Is there a way to get this to work? I tried a contact field that allows…
-
Is there any API by which i can import the Gantt chart created on smartsheets into my product?
-
Control Center: Published Link
I've got a control center blueprint that automatically provisions sheets from an intake sheet. Is there any way to automate publishing a sheet, setting the published sheet view, and pulling the published link back into the intake sheet? My template is set as published, but the sheets that are provisioned from it are not.
-
Control Center: Summary Data on a Different Sheet
In a Control Center blueprint, is it possible to send summary data to only one metadata sheet, then reference that data in column formulas (i.e. JOIN) from the project sheet? The need to have the summary data at the top of my template sheet is really screwing up my workflow. I have sheets that I want users to access via…
-
Electronic signatures on Smartsheet Forms
I was wondering if there is a solution yet for electronic signatures to be captured within a Smartsheet form. We have visitors and contractors that are required to sign in and out when they enter and leave the building. We are trying to reduce the abundance of paperwork by making this form electronic; however, due to…
-
Datamesh to populate links to sheets
Hello, I have a Datamesh that: Reads a row-report gathering several sheets Looks to feed a separate sheet with the link to each of the sheets gathered in the above report. For that matter I've setup the Datamesh with 'Data Mapping Format' = "Create Cell Links" This Datamesh has 1 field (in addition to the lookup values):…
