-
Edit In PowerBI or Self Trigger Update Request?
Hi everyone, I've used Smartsheet for four years and pride myself on being able to make Smartsheet do as much as as I can get out of it... and I've hit a point I can't figure out myself! Help! I am displaying basic project info in PowerBI with a nice button to add new data to the dataset. BUT ... we want/need a…
-
Re-using an entry from a project already provisioned in th intake sheet.
We manually archived a project but didn't delete the row in the Project Intake Sheet. Now we need to re-provision a folder toolkit for that project and I'm wondering if using the same entry (just unchecking the "Created?" column will create any other issues. If that's the case, deleting the entry and using the same info…
-
How to load excel dates into DataTable via DataShuttle
Hello, I am trying to load dates from an excel file into DataTable using DataShuttle. The excel file is an attachment on a Smartsheet sheet. DataShuttle is configured to load the date field as a date. I am able to load the date values into DataTable but DataTable does not recognize these values as dates. I also tried the…
-
Google Calendar not Pulling Colors
When publishing a calendar to Google Calendar, my colors for events do not remain. Has anyone found a way to work around that same issue?
-
Bridge sort sheet by two columns
We're using an HTTP Call to sort a sheet based on the values within a column. Is it possible to sort by TWO columns within the same query? If so, I'd be grateful to know how the parameter body should be updated to accommodate. E.g. Sort by "Manager" then "Resource Name" Form Parameter - Body = {"sortCriteria":…
-
Jira Connector Set-Up
Upcoming need: I have (say) 30 separate projects in Jira, each with a field called "Status." I have a Smartsheet sheet with those same 30 projects, also with a field called "Status." When someone updates the Status in Jira, I want that new status to show in the Smartsheet "Status" field. I don't have the Jira Connector…
-
Can't get my Assignees in Jira to sync over to Smartsheet
I've set up a connector to track certain Jira tickets over in Smartsheet as well. Even though I used the Contact List type of column, the Assignees are not coming over to the Smartsheet through the connector. I've tried everything I can think of to fix this. Does anyone know why this happens and how to fix it?
-
Missing email fields in the Docusign integration drop down.
I need to send the generated documents from SS to Docusign to be signed. I have separate columns for 5 different speakers with various information about them and each of them has an email column (set up as a Contact list for the type of column). However, when I try to connect to Docusign, those 5 columns with emails are…
-
Outlook integration in .eu region
Hi, Does anyone know if the Outlook integration works with .eu accounts? I can get it to work with .com but if I sign-out and log back in as .eu it won't work.
-
Salesforce -> Smartsheet Connector Issues
Hello Community, My team has been using a the Salesforce/Smartsheet connector to feed live data from Salesforce into Smartsheet. Recently, a number of fields/columns are not receiving information. Only the primary column is being populated. I have tried creating a duplicate sheet and re-created a duplicate workflow and am…
