Dynamically Updating Dashboard Using Forms

I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I can choose which row of data I want to show on the dashboard (aka choose which project I would like to visually see)? Thank you!

Find more posts tagged with

Forms

Sheets

Project Management

Enhancement Request

Comments

Chris McKay

Hi,

I suggest using a Report to do what you're looking to do.

Simply add a new column in your data sheet (perhaps a checkbox) and name it something like Display.

Have the Report pull rows out of your data sheet only when this checkbox is ticked.

Then embed the Report in a Report Widget on your Dashboard.

Kind regards,

Chris McKay

oberning

Hey Chris!

This would work, however I would like to try and maintain the visual look of the dashboard that I currently have laid out. I could, potentially, create individual Reports for each field and then try and lay it out best as I can, but that would be tedious as well.

If they had a simple drop down box (with all of your primary column names), and then had widgets auto-update according to the drop down value, that would be amazing!

Thank you,

Oliver Berning

jsimek

Any solutions to the last reply!? I am looking to do the exact same thing vs. making 150 dashboards. A dynamic dropdown list where the metric widget would update text?

A feature addressing this need would be quite valuable for me. I have a project portfolio sheet, one project per row, many columns serving as fields collecting different high-level data about a given project. A dashboard functionality, where I can visually lay out the different fields. Then having slider buttons where I can cycle through different rows, that is through different projects, would generate quick one page overview for every project. Currently this is not possible in the dashboard. Any plan to introduce this functionality would be helpful to know.

Sai Srinivas

A solution like this is what I have been searching for. It would really add lot of value if the dashboard gets updated for each and every row being added to the the smartsheet

Andrée Starå

Hi Sal,

Not sure I follow!

Can you describe your process in more detail?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Ezra

Yes, I agree. Some form of a dashboard report project-filter drop-down to give the viewer of the dashboard (for example) all projects in the past six weeks in the Dinosaur account... or filter it to the past three months in the Jean Jacket account.

The one setting up the dashboard would have to have a default filter in place, and the report would have to have some way of receiving the filter options... but nothing's impossible.

Andrée Starå

Hi Ezra,

That would be an excellent addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ATRIP

https://community.smartsheet.com/discussion/comment/175821#Comment_175821

Hello Andree,

We as an user of your product and trying to promote it by suggesting the necessary enhancements for the proper adoption and usages. These inputs should be taken up by Smartsheet organization on priority basis and do the needful. Not to ask the users to give you the requirements in plate and do the legwork to collect and describe the requirements in your prescribed "Enhancement Form".

Smartsheet needs lots of improvement immediately to create it place as a reliable and efficient product in Project Management. Otherwise, other competitors are listening and may offer right and efficient product to the users.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
True up and the admin center
Hello We converted over in July to the usm. We have alot of discrepancies where people are in usm and not the admin center and vice versa. Is anyone else see the same and feel this is an issue? Also, I would like to brain storm with the group as to how procedurally you will be doing the true up process and terminations as…