-
Jira Connector Error
I have the Jira connector setup to only pull information from Jira to Smartsheet. It works well however, some tickets I get an error of "Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request You do not have permission to edit issues in this project.". I'm not doing a pull from Smartsheet to Jira so I…
-
Return text after calculating quarter dates
Hi - I want to return a value of "Q1-25 based upon a date. I have a separate sheet with 47 rows going out for 3 fiscal years. Fiscal year starting November 1st. From other posts I've read (Love this Community), I have learned how to calculate the Quarter but it's not calculating the year or returning the value. This is the…
-
Pivot not showing Immediately for Execution Frequency
Any idea why I do not see "Immediately" as a frequency to refresh a pivot table? I see it in another pivot I have, but not this one which runs off a report rather than directly from a sheet. Gotta say, the Pivot App lacks functionality compared to excel, can't easily filter without sending things to a report first. Ugh.…
-
Control Center Profile Data-Appearing in Date column to the right of Primary
Either I am unclear on how the profile data is supposed to populate into template sheets, or this is a bug. When I do not designate a Target Column for Profile Data in SCC, it should appear in a text/number column to the right of the Primary Column. However, the columns to the right of my Primary Column are designated Date…
-
Data Shuttle Only Deleting Rows
Hello, When running an upload workflow earlier today one of my workflows only deleted rows and did not add any new ones. I had to rerun the workflow in order to get the sheet populated with data. This caused an issue as there is a pivot ran on the sheet and as there was no data it reset all of the manually input data into…
-
Smartsheet / Hubspot Integration to Kick-off workflow in HS
Has anyone used Smartsheets forms to collect data and attached documents to then have it transfer that over to hubspot and attach it to the company record to kick off a workflow? I am looking for some tips / training on how to do this and can't seem to find anything. Help would be greatly appreciated! Tammy
-
Transferring a dropdown multi-select column into PowerBI
Hi Community, I'm hoping someone might have a suggestion for how to best translate a dropdown multi-select column in Smartsheet into a PowerBI slicer. I'd like the PowerBI slicer to mimic the Smartsheet dropdown options, but instead I get a list of every unique combination of all the options. See photo: Here are the…
-
Control Center Customize Profile Data
Hi All, Does anyone have a better explanation about how/what the Target and Approval column fields are used in Control Center? There's a brief overview in the SCC videos (https://www.youtube.com/watch?v=UOWP_nfVnZ0&feature=youtu.be&t=2447) where they recommend using the Approval column, but I'm confused on what the purpose…
-
Bridge: Reference data from child workflow in the parent workflow
Hi, I am following Reference data from a child workflow article to get a very basic operation to work. I have a child workflow which sets text using the String tool. The parent workflow calls this child workflow (for no. of runs = 1 and no params passed). The parent workflow references the value of "Compose Text" from the…
-
Is it possible to have a dynamic view embedded within a dashboard open with a preset filter?
I have a number of dynamic views in a dashboard. Each of these dynamic views has defined shared filters, however when the dashboard refreshes the filters are turned off. They are still defined, but the user need to choose the filter. How can the filter "stick" when the dashboard is refreshed? Thanks, Sara
