-
Can I highlight non-working days and holidays in report based gantt charts?
I have a report referencing several worksheets that I use primarily in gantt chart view. When I print it's gantt chart, I would like the weekends and holidays highlighted the same way they are in a worksheet based gantt chart. Is this a check box I am missing somewhere?
-
Report based off Check box?
Hi Smartsheet community, Under "What" in Report builder, I am trying to go based off of a checkbox column but that column is not showing up as an option. Check box columns have shown up under "What" in the past. Any idea what the issue could be/how to solve?
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Report Builder: Include Only Top Level Gantt Chart Rows
Hello, I'd like to design a report of overdue projects in my Gantt chart. I can easily design a report showing all incomplete, over due tasks. But what if I only want the top level items on the report ... those that are not indented? Using this forum, I read an answer to another question that prompted me to add a new…
-
Merging Cells and Exporting Reports to PDF via the App
Hi there, I love Shartsheet, but one constant aggravation for me is the inability to merge cells. In my quest for a solution, I've come across a few posts on the blog (some as old as 2015) where similar requests were answered with a generic "we'll pass this along to our developers" type response. Just curious: is this…
-
Best Practice: Sharing a Report
I have several sheets that contain course development information. Some of the information is private and not intended to be shared . I created a report for a vendor that pulls information from one sheet (and that one sheet pulls data from 4 or 5 other sheets). Our goal is for the vendor to update the Status column in the…
-
Include Parent Rows in Reports
Can the option to include parent rows be added to the report builder? This would be similar to the checkbox that is offered on filters for columns when in a sheet.
-
Clone sheet and reports between accounts
Hi there, I'd like to take a sheet and some reports that operate on that sheet, and clone them over to a new account programatically. I'm able to share the items, copy them, and then un-share them programatically, but the reports then point to a non-existing sheet. Since I have quite a number of reports I'd ideally like to…
-
Added row in smartsheet cannot be retrieved in reports
I have a sheet with all the data I need for reports, dashboards and other summary sheet. My trouble is, whenever I add a row in the source sheet, it is not reflect in my reports. Example, I have a report with a simple criteria/filter of retrieving any row with type = PROJECT. However, the newly added row is not reflected…
-
Reports not listing entries when it should
Hi there, We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects. I have just recently added few rows, all identical, on all 16 sheets. When I run reports, it does list certain rows (newly created). Puzzled, I simplified the report to the bare minimum: I now…