-
Count number of days in date range that fall in current week
Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours required to complete the task. As some tasks will take multiple weeks to complete, I…
-
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…