Hi all. I would like to create a high-level report/dashboard that extracts select rows from different sheets and displays them horizontally like in the attached image. Is this possible?
I figured out a somewhat long round-about way to achieve this. First, assuming all of these projects are listed with this data in one sheet, add an additional column (i.e. Project Designation) as a drop-down, single select with the options: Project A, Project B, and Project C. Select the designation for each milestone. Column can then be hidden, if cumbersome.
Next create a row report titled Project A. Add your sheet, with columns for Project Designation, Milestone, Start, and Finish. Filter by Project A (Project Designation is equal to Project A). Hide Project Designation column.
Duplicate (Save As New) report and save as Project B, then filter by Project B.
Duplicate report and save as Project C, then filter by Project C.
Add all three reports as individual Report Widgets to dashboard and line-up as required. Result should be similar to attached screenshot. Once the first report is created, it's super easy to duplicate, so it goes fast.
Thank you @jodyh. I think I follow but will need to play with it. Regarding your comment "...assuming all of these projects are listed with this data in one sheet", I am trying to extract these milestones from individual project plans (so Project A is one SS, B another, etc.). All of the plans contain the same information/dates I am trying to extract.
@Tyler C. Gotcha. Yeah, I was meaning that my directions were based on Project A, Project B, and Project C information all being listed in one Sheet (I was guessing). Like this-
I just wasn't sure how you have your data organized, but hopefully you can still get your dashboard how you'd like it. :)
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello Smart-Heads! This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet. The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.