-
How to get page 2 of the reports list from the API /reports endpoint?
Hello! Perhaps I'm being dense, but how do you get page 2 results from the API using this endpoint using CURL: https://api.smartsheet.com/2.0/reports I can see that there are 3 pages from the response to this endpoint: "pageNumber": 1, "pageSize": 100, "totalPages": 3, Thanks in advance.
-
Sheets, Reports, Dashboards and Workspaces now tied to Smartsheet Plans instead of Individual users!
Hi Community, Today, we’re excited to announce that sheets, reports, dashboards, and workspaces are no longer tied to individual users but instead they are tied to Plans. This means that as users change roles within organizations, leave organizations, or have their licenses removed, business workflows and processes built…
-
Alpha order or Sheet Order Column List
When working with columns, such as creating a report or Dynamic View, it would be beneficial to have a choice when designing to either add all columns in alpha order or add all columns in the order they appear in the source sheet. Currently, you have to add them one by one and scroll through the alpha list to put them in…
-
How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
-
Merged: Updating Reports Sent as Attachments
This discussion has been merged.
-
Reporting on top parent rows only, not all rows with children
Hi all, I have my projects set up as workstreams rather than phases, with a helper column for phases. I want to add a dashboard widget that lists out each workstream and its % done . In my hunt through the questions I found that I can add a helper column to indicate if a task has children like this: =IF(COUNT(CHILDREN()) >…
-
Change default time frame in published calendar view of report in Dashboard
I have a dashboard that integrates a calendar view of a report. It always opens to a time window of one month, but I'd like to make this default to two weeks. Can this be done? Thanks.
-
Create a dynamic unique count metric sheet for a leaderboard
Hi All, I'm looking for a way to create a leaderboard from a sheet that tracks incoming submissions. We want to track the unique visitors and how many submissions each has created over a period of time, and I'm having zero luck. Any help would be appreciated!
-
Form Filler
It would be cool if instead of going from form to sheet it could go from sheet to form. I send out a lot of paperwork that if I could just populate with the info from certain columns, it would save me a lot of time or at least give me a fairly complete first draft of the paperwork I need to send out.
-
Formatting the Sheet Name Field within a Report
Hi! I would like to know if there is a way to format the Sheet Name column within a report. I would like the ability to middle align, and wrap text. Also, is there a way to remove row colors within a report without removing the colors from the actual Sheet? Thank You!