-
How to add Developer Tools to GOV account?
Hi, I want to add Develope Tools to a GOV account so I can than Create New App which will help me in generating a ClientID and ClientSecret. I need those to give users a log in page. I am able to create developers account for non gov account, but not for gov. Please help with steps for developers gov account. Thanks
-
CDATA import into Smartsheet cause apostrophe problem
We are using an external tool from CDATA to import data into Smartsheet from MS SSIS. We have recently run into an issue where the data load inserts an apostrophe in front of the string value we are loading. We've checked the outbound flow from SSIS and the apostrophe is definitely not there, so Smartsheet is doing this.…
-
Get working hours and days from API for Project
Hi, How could I retrieve "working hours" and "working days" using API for Project files? In Smartsheet it can be found in Project Settings (see picture below). Didn't find this info in documentation. Thanks
-
Chat function within Dashboards
Good afternoon, My team and I are creating dashboards for each of our clients. The format we have has been close to perfected, but when presented to our CEO he mentioned the need for a chat/comments function within a dashboard (that is not just linking another sheet to the dashboared). To my surprise there is not any type…
-
Automation emails to Microsoft Teams channel are not working
We are testing sending automated Smartsheet tips and tricks email to a Teams channel, however, running into a few problems which make this functionality not useable. any hyperlinks within the texts are not clickable once posted in Teams. I have read the various communities posts and put the URL into it's own field and…
-
Row and Cell formatting issue via the API picking up previous row strike through
HI. I'm creating rows in Smartsheet via the API We're are storing the Sheet and Row ID in the originating application. Later on someone might decide that they no longer want this record, but rather than delete it from Smartsheet we update the formatting of that row. Reading the row in, updating each cells formatting so bit…
-
Metrics: Using the metrics template and metadata
I have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metadata report and a metrics report Problem: I have to manually link the portfolio,…
-
Populating new Cell with a Contact(s)
I have been reading the SDK for Smartsheet and can't find support for how to populate a cell in a Contact List type column programmatically given the name of a person in the contact list (language C#). I have line of code that builds the cells, I then add that to a new Row and push to a sheet using AddRows() method. I am…
-
Transforming data from API in Power BI
Hello Smart People! I need to report on some data that I have compiled from many sheets in a Smartsheet report. The reporting tool that we have is Power BI, but the connector to Smartsheet defaults to IE, which isn't supported by Smartsheet. Apparently, this is a bug, and the work around is to add smartsheet.com to the…
-
Callback URL not receiving callbacks, but webhook lists last successful attempt.
Hi all, I'm am trying to integrate Smartsheet webhooks into my teams Power Automate flow. I have created the hook, enabled and verified it using HTTP response connector in PA. When making a change in the sheet as required my PA flow does not trigger. Getting the hook list shows a more recent timestamp for…
