-
How do I count for something that has not already been used in a cell from a multi cell dropdown?
Hi all, I need help! From this list of machines, I would like to know which machines are available on a particular day.. I have a date column on my sheet. How would I solve this? Much appreciated!! Thank you!
-
My Tasks Report - source formatting not coming through, and privacy
Hi all, I'm rolling out my masterpiece to a group with high expectations today! I'm worrying about 2 things that maybe someone knows the answer to: 1 - The My Tasks report isn't showing the source formatting. I don't see other questions in here re that. 2 - What are the right sharing settings to allow them to fill out…
-
Summarizing a Report
I have recently started working with Reports and like the summary functions but whenever I add a summary, I get a TOTAL line at the top of the report and there are times I DO NOT want a total. For example, I am creating a Financial Statement Report that has approximately 100 lines which I can summarize into "Sales",…
-
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.
