-
Jira Connector Error: Input collection contains multiple instances of the same element
One of our Jira connector workflows is throwing the error below. What does this mean exactly? "Error code: 1137. Error Message: Input collection contains multiple instances of the same element." Also, the connector is only pulling in 977 of the 994 issues that meet the JQL query. I have looked at the 17 issues that are not…
-
Use "today" as Data Shuttle filters
Hello, In Data Shuttle I would like to create an offload from a sheet by selecting "greater than today" as a filter on a Date field of my sheet. I succeeded with "contains" "2021", but am unable to have something that works when trying with Today(), nor Today in the criteria box. And it does not work with a specific date.…
-
Datatable Filter Question on dates
I am trying to construct a filter that will filter my data based on a date field, that will show data that is between 30 and 60 days from todays date but I am really struggling to create a filter that actually works. I have tried using date is in the past and adding criteria to filter out the desired data but I still get 0…
-
Calendar App: Glitch with Sharing permissions or am I doing something wrong?
I've built an events calendar in the Calendar App to share with employees inside my company. They should have view-only permissions and not be able to share with anyone outside the company. I have "Sharing" enabled with the appropriate domains. However, viewers are able to EDIT the calendar items when they don't have any…
-
Best practice to manage dynamic views without Content Centre?
Hi, My agency doesn't have access to Content Centre. What is the next best practice to 'retire' rather than delete a set of Dynamic Views, please? I'm finding that the list is becoming unwieldy but don't want to delete the DVs until I know they won't be required again.
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Pulling Column Data from Multiple Rows for Document Generation
I currently have a tracker that records absences for individuals and assigns points per policy. Each absence instance for each individual is it's own row. I want Smartsheet to generate a PDF for an individual with each of the separate dates where "Points">0. I have tried different combinations of functions, but I cannot…
-
Sync Smartsheet Calendar with Outlook Calendar
Hi, I am looking for the latest and greatest training information regarding how to sync your SmartSheet calendar with your outlook calendar. If anyone can help, please let me know. Thank you, Allison Bishop
-
Uploading data into form templates
Hi, I use Smartsheet for tracking sales quotes through to engineering jobs. We've had success with using multiple sheets from initial enquiry, through to job set up. But there is more that we would like to do. Is it possible to create a form with pre-determined information? E.g. could I create a form that is populated with…
-
Auto-number column
Hi, I added an auto-numbering column to an already-populated sheet a few weeks back. When a new row is added via a form it's started at 1. Could you provide pointers on how the I can configure the column to take account of existing rows and how the numbering would continue? (Right now I've got two rows with "1".) Thanks,…