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,…
Updating a cell in a column formula is not supported
Is this really the case? Is there no means of using the API to update the format of a cell that is in a column with a column formula defined? We're trying to use column formulas, but have automated mechanisms in production that format by row. This error is a problem. Thank you.
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…
Dropdown List Per Cell Using API?
I have been doing a ton of research on how to do a dropdown at the CELL level, instead of column level. All signs point to this being a lost cause, as the feature has been being requested for 5+ years now. However, one forum response indicated this is possible through API. Does anyone know if this is the case? If yes, how…
Save as new template set not saving all files
Hi everyone. I have template set consisting of appx 38 sheets/reports/dashboards in total. I have set it up with minimal info within it so every new project I start is a blank canvas but has all the automations and cell links kept. only thing that reallly changes is the project plan. unfortunately now when I try to save as…