-
Calendar (Dynamic View) still allowing locked row to be editable for one drop-down column
I have searched and searched and cannot find an answer to this. I have set an automation to lock a row when a certain selection is made from a drop-down column. Everything in that row is locked on the main sheet for editor users. However, once the row/event is viewed in Calendar (Dynamic View), the details card has…
-
Project Template auto Update from Intake Sheet using Control Center
Hi, I have a situation where I want my project templates which are provisioned via Control Center to link to cells in the intake sheet each time a new project request is submitted and provisioned. For example: whenever an intake request is submitted and a template provisioned, I want the newly provisioned template to…
-
Is it possible to hide rows based on value of a column in Dynamic View?
Hello, Using Dynamic View to allow users to see a report where we do not want them to have actual access to the sheet driving the report, so we have a report created that the dynamic view is on. Currently the report is pulling all data based on a couple filters. Ideally the group that owns the sheet and report can see…
-
Trying to understand smartsheet - data integrations
I am a freelance data scientist, and have been given temporary access to smartsheet to evaluate it's capability, and possible opportunities for integrations to support data-heavy work. My standard analytical tools are R and python, both of which have advanced data-processing, analytical, modelling, and visualisation /…
-
Data Shuttle Not Mapping Certain Columns
Hey All, I'm working on a Data shuttle project, and for some reason it's not mapping a couple of columns on the upload workflow. The columns in question are: Block Row Number The offload workflow seems to work fine, as it shows up in the Excel file it creates, but I can't get them to work in an upload work flow.
-
Data shuttle - uploading data from Excel sheet
Hi everyone, I am looking for a workflow, that copies a data from excel file into Smartsheet (which also captures data from the form created within the sheet) without having the team members to access Smartsheet. The reason for considering this upload is, sometimes there will be a bulk data which just need to be copied…
-
Smartsheet and Sharepoint Embed Issue
Quick summary: I am no longer able to view embedded Smartsheet items on some Sharepoint Online sites even though I am the owner of said Smartsheet items and I have Full Control access on Sharepoint. I cannot complete the login (see screenshot) as no login window comes up when I click the button. I am reaching out to my…
-
Disable user's ability to start trials
We just had a licensed user who is not a sys admin start the trial for Data Shuttle. We do not want users trialing things without our approval first. How do we turn that ability off?
-
Automated integrations with Employment Hero, Xero, Artisan Plus.
I would like to be able to import data from several different platforms into Smartsheet and have Smartsheet update some data in a 3rd party platform. There's not much data to shift, so I can't afford an expensive solution, but if it's possible to automate that would be great. Specifically, I want to have our staff and…
-
How will the new email OTP login method impact Live Connector?
How will the new email OTP login method impact Live Connector’s 32-bit ODBC connection?