-
Report Builder: Gannt Chart Predecessors Not Working
I'm trying to run a single report of my 5 project schedules so I can quickly see aligning milestones and deliverables. However, when I run the report, all of the predecessors become unconnected and the columns report 1 predecessor. This is kind of a big deal for my reporting. Anybody have a fix for this? Thank you!
-
Lock report filters, while cells can still be edited
Hello, I currently have a dashboard with multiple reports pulling from the same grid of data, but each filtered a specific way. Is there a way to keep each of these reports editable, while locking the filters from editors? Thank you.
-
Report Edits and Workflows in Main Sheet (Workflow not working)
My team makes edits to a report instead of the Smartsheet that houses my large database. I am finding that information goes bi-directional between my report and my database but the workflows in my database are not copying rows to other sheets I share out. I tested my database workflows by changing data in the main sheet…
-
When will report card views be editable on dashboards and workapps
The sheet card view functionality works so beautifully on dashboards and workapps 😍 (image attached of sheet setting options on workapps). Will this be available soonish for card views on reports? Currently, the only editable report option is grid view on workapps. The workaround I'm implementing is to add the card view…
-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
sheet summary report not counting multiple different responses given in one cell
Hi all, I have a summary sheet report with fields drawing responses from surveys collected. The surveyed people were able to tick several possible answers in the surveys. These multiple responses appear in one cell, e.g. "how did you find the event?" and the answers are "fun, educational, accessible". I would like the…
-
Health Status on Report
Hi All, I've been building my files and reports. I've gotten my RGY formulas down, however, how in the world do I get it to give me a RGY health summary as it does for the other columns? I have a report that pulls in each rep as I have it below, just missing that one piece! Am I missing a step?
-
Creating an automated report
Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is check, that that task is added to the report and displayed on a dashboard. Is this…
-
Convert Numbers to Text so I can show a range keeping the comma delimiters
I have two columns of data showing prices, say $1,100 in one and $2,200 in another. I want to display this as a range in a report as "Your price is $1,100 - $2,200". I used this formula: "$" + $[Report Low Price]@row + " - $" + ($[Report High Price]@row which returns "$1100 - $2200", how can i have it include the comma…
-
Build a report that includes user input
I have a smartsheet with approx 30 parent rows and anywhere from 30-65 child rows per parent. I need to provide numerous individuals with reports for individual parent rows. Can a report be 'dynamic'? i.e., report requires input from user (preferrably by selecting from a dropdown) and then the report is generated. I…