-
Report fetched through API is restricted to 450 rows only
Hello, Please note that I am using Smartsheet api to fetch a report that has around 500+ rows. Syntax - https://api.smartsheet.com/2.0/reports/<report id> This is only fetching 450 rows and I have no idea where the remaining rows went. Based on few posts through Google search, I tried pagination ways like - #1…
-
Gantt View on a Dashboard - issues with Gantt showing data accurately.
When using a Report to pull data from a Sheet, the report allows you to configure the Gannt in various was (day/week/quarter, etc). When displaying the Report on the DB, and wanting to view a part of the Data, and the Gantt at the same the ---> the Gantt isn't proper. Ou use-case is shipping goods measuring Pickup Date to…
-
Merged: Headers and sums fields in report exports
This discussion has been merged.
-
Merged: Formatting for Report Headings / Groups
This discussion has been merged.
-
How to capture Actual Finish Time for a Cutover Task
I have created a cutover Plan in Smartsheet and all tasks in the plan has these columns : Task, Duration, start Date and Start time, End Date and End time, Actual Start and Actual Time, Actual Finish Date and Actual Finish time. I am able to calculate start and end dates based on duration but I’m only able to capture…
-
How do I exclude information on a report that uses two sheets?
Hi Smartsheet Community, I'm currently managing two sheets for a non-profit organization, and I'm seeking some guidance on how to generate a report for their fundraising events. Sheet 1: Checkbook - This sheet lists each disbursement, daily total deposits, and the checkbook balance. - It includes a dropdown column with a…
-
Rich Text Format in Sheet Cells
We have been converting all our projects to Smartsheet and now have about 86 projects loaded. A big issue for us is, (I would like to know how many other people would want this) we have a column in our status reports that go to our VP's called "Status Comments". The VP's are used to seeing comments with bullet points,…
-
Published report doesn't display for others
Hi, I have shared a report with the publish option, available to anyone with the link. Despite that other people only see a blank page. They should have records listed: Why can this be? I thought the point of the publish option was to be able to share it with anyone but even those with smartsheet access can't see it. Any…
-
How to show a chart (stacked?) of count of each task status + number of late tasks per status
Hello, I have a typical project schedule sheet with tasks, start/finish dates, etc, and have a Status column with several different levels of task status, which includes several status levels (process steps) in between "not started" and "complete". I also have a check box column marking when a task is late (start and…
-
Sorting date via the Grouped-by parameter
In the Report associated with our Dashboard, Smartsheet doesn't seem to allow us to sort by the 'Request Status' columns (which is a Drop-Down menu on the Form and Sheet). Is there a Work-Around? We want these displayed in a particular order based on which step the order is in, based on the Request Status. Thanks for any…