-
Dynamic View - Forbidden resource
Hi I'm new to Dynamic View and I'm in the process of creating a view for a group of people. On the General Tab, I am using the Restrict view by current user and have selected the contact column in the sheet. On the Sharing tab, I have selected a Shared Group that I created. I have not put any of the users in the Admin or…
-
Smartsheet-Jira connector - Jira Story Points syncing to Smartsheet as text
Our company has been using the Smartsheet-Jira connector for over a year now. Today I discovered that Story Points are now (suddenly?) coming into Smartsheet as text (numbers appear as '2.0 in the cell, for example). This is affecting the story point metrics I have put together. Has anyone else come accross this? I'm not…
-
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…
