-
Identifying current data in DataTable
Does anyone have a good way to identify good records in DataTable? DataTables can be updated from an external data source using Data Shuttle but there is no way to automatically remove DataTable records that are no longer in the source data. This means DataTables will contain bad data. My current workaround is to include a…
-
Smartsheet Not Provisioning as of 2024/08/06
We experienced some unusual behavior when provisioning work last week, Thursday (August 1st), but the issue seemed to have resolved itself at some point on Friday. This morning, the provisioning doesn't seem to work. Control center does not populate the column I selected in the Intake Settings tab Project link column with…
-
Data Shuttle - Remove row that is no longer is source sheet
I use Data Shuttle to upload current enrollment data for our courses. I have a unique identifier because the source sheet has duplicate entries, but I only need one in entry in Smartsheet. Has anyone come up with a solution to remove the a row that is in Smartsheet, but no longer in your source sheet? Sometimes courses are…
-
Can Smartsheet be integrated with Microsoft O365 Planner?
In our organization we have 2 tools utilized for planning tasks: Smartsheet and Planner. I am assessing if there is a possibility for users to choose to work with only one tool - Smartsheet for example - however to be able to integrate in Smartsheet the tasks assigned to them through Planner (based on some sort of…
-
Workflow owner has been deleted
We had a user who ran our Salesforce Integration between SmartSheets and Salesforce. He had exited the company and the team over SmartSheets deleted his user. You can 'see' the workflows that were in his name that now say "missing owner". Is there any way to reassign? If we have to recreate the workflow is there any way we…
-
Using a filter to show information in dynamic view.
I am very new to Smartsheets so I hope i'm able to make this make sense… I would like to create a dynamic view the populates based on a selection from a drop-down list. Specifically, I want site managers to access information about their site by selecting the site name from a drop-down. We have lots of site managers but…
-
Date in Dynamic View not editing
Hello, I have a couple of Dynamic Views where the date columns in the source sheet have the same setup (see figure 1), however one of the dates field in the view is showing as not editable (figure 2): Figure 1 Figure 2 It's important to note that the setup of the field in the DW it's not as "Read-Only", and the columns in…
-
Data Shuttle - Additional Charges - Separate from Premium License Fee
Hello, our organization was notified recently that we will be incurring a quarterly charge for each data shuttle. This is disappointing because I was on the premium plan for some time and have developed many of these to help streamline our data. This will be a huge financial impact on our account. Has anyone else seen this…
-
Data shuttle error with populating a dropdown
Hi. I created a workflow that offloads a single column from a sheet and then a subsequent workflow that uses that offload to populate a dropdown in another sheet. When I ran initially it worked great but now i cant get it to add updated info after it runs again. New data has been added to the offload file but i cant seem…
-
Outlook Calendar events populating Smartsheet?
Good morning, I have attempted to search the answer but not having much luck. My question is: The team I am apart of currently use Outlook calendars to record the various event sessions taking place throughout the day in different rooms. We have begun using Smartsheet to record the events so we can display the statistical…
