-
Is there any way to create dynamic dropdowns?
Hi all, we have explored many ways to create a dynamic dropdown from one sheet to another, and we found the most useful one was using data shuttle but we have a limitation in it by 50 workflows for the enterprise licence. below are the few queries we have: 1) Is there any way that we can get the values from one sheet and…
-
can we create template Data shuttle workflows to Control center?
Hi all, we are currently using Data Shuttle workflows for the Dropdowns, is there a way that we can create it as a template so that it can be copied in the control center and when we create new projects it creates a new workflow based on the template for the new workspaces sheets? Thank you.
-
Importing MS Project into Smartsheets BAD problem
Hello, Amazing Community, I am hoping someone can share with me some clarity on my current issue. I am trying to import an MS project file into smartsheet gant. The Problem is that though all the data transfers over fine, the dates and dependencies are completely off. There seems to be some type of disconnect that I can…
-
How to authorize Teams to connect to Smartsheets
I am trying to connect Teams to Smartsheets. I have installed the app within teams and the bot is prompting me to allow access and displays an Allow Access button. When I click it, it takes me to a browser window that prompts me to deny or allow. When I click Allow, I receive an error indicating that the Authentication…
-
Turning off Control Center
Hello, Question about Control Center - is it possible to "turn off" control center and still be able to utilize the environment/solution that was created (even though it may be more manual)? From my understanding, auto-provisioning of our project sheets will then become a manual step. However, I'm not familiar with the…
-
Blueprint for Different Project Plans
We have different sized projects (small, medium, large) and each one will have a different project plan template. We currently have an intake sheet setup with Blueprint so that once a project is approved the standard template is used. However, we would like to use another column in our intake sheet that shows which size…
-
Datamesh Pulling all rows
I am using datamesh to lookup a value in my target sheet and bring in some columns from my source sheet. Source Sheet, is a JIRA integration bringing in multiple rows for JIRA Tasks. Target Sheet, is a project plan where we want data on specific JIRA IDs. When i create a datamesh config to only copy the JIRA ID identified…
-
Actual hours in Utilization report
Hello all, Just a quick question. If people do not report hours in organization (meaning that i don't have any "incurred "hours confirmed or unconfirmed), but do have assignments to the projects, my Utilization report is supposed to show the "actual hours" based on their assignment, correct? Currently it doesn't seem to be…
-
Connected User Count and Published Items
Hi, Hoping the brain trust here has experience of this. We are on Smartsheet Advance and on a certain tier of Connected User and I'm curious if viewing a Smartsheet object on an external web page via its embedded publish link increment the Connected User count? For example, take the publish link for a dashboard and embed…
-
Bridge Workflow Scalability (need to duplicate x 100)
Hi there Smartsheetians, The Situation: I have a Sheet connected to Bridge workflows (1 Parent and 1 Child) - It's a FedEx tracker API call that returns various package statuses triggered by entering tracking numbers into the Smartsheet sheet. But, all 100 stores cannot use the same sheet otherwise there would be…
