-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
-
In Calendar App/Quarter View, can you change the Fiscal Year output of year? (Q1-FY2022 vs Q1-FY2023
Our fiscal year runs April 1-March 31. In the Quarter View, all events running April 1, 2022 through June 30, 2022 are showing up as FY2023. However, April 1, 2022 is the START of fiscal year 2022 for us. I would like the Quarter View to show it as FY2022 Q1 and not FY2023. Is there any fix for this? (See below. Events in…
-
User Provisioning with AD
A couple of questions about the Active Directory integration. We are working on getting our Smartsheet integrated with Azure AD for SSO and SCIM User Provisioning. 1) We'd like to issue non-licensed accounts to everyone on our domain who isn't already issued a license - will current licensed users experience any…
-
Stacked Bar Graph - Reflect 3 columns
Can't figure out how to use 3 columns for a staked bar chart in Smartsheet. Please see attachment. For example, I'd like one column to show all costs for January, with Amy and Joe's costs would be broken out by color. Is this possible? If yes, could you please explain directions? I can only figure out how to use two…
-
Pivot App Zero Values
Hi All, I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals. Other than creating new…
-
SharePoint document link as an option under Attachments
It would be great if as well as all the Dropbox, Google Drive, oneDrive and other file attachment options, we could also have a direct 'Link' option for SharePoint document libraries, document sets/folders. Leading practice for document management suggests not to store documents in proprietary databases (such as Smartsheet…
-
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
-
Does anyone have experience with handling JWT data with Bridge?
We're using Google PubSub service to receive updates notifications and they come with JWT encoding in the web hook endpoint. Does anyone have managed to decode JWT payload in Bridge since we cannot run libraries in Bridge and there's no working Javascript to decode it. Thanks!
-
What is best way to move SmartSheet column data to D365?
It does not appear that Data Shuttle can move data from SmartSheet to D365 tables. I imagine that we could build a custom flow using Power Automate assuming Power Automate has a connector to SmartSheet. But just wondering what other solutions or ideas are out there that someone has successfully implemented. I see there is…
-
DataShuttle Error: Access Token is Invalid
Hi, I have a datashuttle that's been working for several weeks but today gave the error: Workflow Execute: Your Access Token is Invalid. I didn't use any API to create this datashuttle, and we don't have JIRA connected.
