-
JQL query is working in Jira but Not in Smartsheet Connector -RESOLVED
RESOLVED - I am trying to use JQL to pull stories from Jira that meet the correct criteria. I need to use a text function to pull those that start with "APC" This query works in Jira project = 'AS' and (project = "AS" AND "Forcasted Release[Version Picker (single version)]" ~ "APC *") order by id Yes there is a typo on…
-
In Sheets- automating Status in Smartsheet from Jira
Is there a way to automate a column in smartsheet with a workflow from a webpage? Below is my Smartsheet, the final column needs manual update, but I'd like to automate. Below is the web page which has a current workflow pattern, i would like for the updated status from this page to automatically update on my Smartsheet.…
-
Use DataMesh to combine multiple sheets
I'm trying to combine multiple sheets into one master list, what is the best way do the config for this please? I want it to pull in all values from source sheets, and if the source sheets gets updated I want it to automatically update the master target sheet. Sometimes the source sheets have duplicates so I want it to…
-
Data Shuttle & Google Sheets?
I need advice! I'm trying to use Data Shuttle to automate an export to a Google Sheet, then use that Google Sheet to feed a Google Data Studio dashboard (I can't use the Smartsheet d/b because I need to use d/b-level filters, which as far as I can tell aren't yet available with the Smartsheet d/b functionality). Here's the…
-
Smartsheet to Excel automated exports (40+ reports)
Hi all, i'm looking for a solution for automated export of reports from our 14 data sheets. Sheets are very big - 50 columns, ~100k - 300k cells. We need to generate specific 40 excel files filtered on 2 - 3 parameters (with a specific structure, i.e. First row of data starting on 8th row of excel file, specific heading…
-
Finding Duplicates across multiple sheets?
Hello! Need helping find duplicates across multiple sheets in one column and displaying them in a report. Any help is much appreciated, thank you!
-
Zotero and SS integration
I'm curious if there is an integration between Zotero (a citation management tool) and SmartSheet. We collect our faculty and resident publications using Zotero because it has a lot of automation, but would like to utilize the data in SS because we can calculate various data based on that. So it there is any chance to…
-
Outlook Calendar utilization
Hi all, How does Outlook Calendar integrate with Smartsheet? I'd like to se an overview of all the task where I am assigned. Where is my actions needed and when? Have to I use Outlook or Task manager for this? Or how are you managing your open tasks? Thanks in advance. Palle Kølln
-
Using Data Shuttle to take a Multi Select Dropdown to Update a Dropdown on Different Sheet
I have done some research and testing around using data shuttle to update dropdown fields. Essentially I want to take what a user selects from a multi select dropdown source sheet to update a field on a target sheet so that only the options they can see in the dropdown are what was selected on the source sheet. I'm able to…
-
Data Shuttle Changing 100% to 1%
When using Data Shuttle to import data from an .xlsx sheet, the decimals from that sheet that equal 100% are instead converted to 1% in Smartsheet. This issue is the same as in this Community post that has no answer or resolution: https://community.smartsheet.com/discussion/90205/data-shuttle-changing-my-100-to-1 The…
