-
Column name not coming over in report
When creating a report, I have a column named "Filled By" its configured as a modified by column. In the report, the naming for the column is Modified By in the report, but I want it to say "Filled By" because thats what it is called in the sheet. Is there a way to correct this?
-
Bubble Chart-Scatter Chart
I've been requested my by executives to create a bubble chart of all the projects in the pipeline to gain a better understanding of priority . The chart will have 4 quadrants, see the attached. I have created columns in my smartsheet project list so the dashboard once completed can pull this data from. How do I get started…
-
Report Builder
We are experiencing issues with the new report structure. On one of our dashboards, the report wasn't working. It's only showing 1 filter. The other 2 filters set up show up with the info but t hey are rimmed in red. A message shows up about completing the filter criteria. You can see that I confirmed it for Parent Row…
-
Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard
I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of…
-
Showing delivered milestones in dashboard?
Hi all, How do I make my dashboard on a project show which milestones have been delivered since xx date, previous month or similar? I have a owner keen on knowing this in Dashboard, but can't seem to find the right solution. In advance, thank you for feedback. Regards Lise
-
Can you create a report out based on a single row of data?
I am using a smartsheet form to collect location assessments and have the data plus additional fields for score calculations populating in a grid. The smartsheet will house multiple, on-going location assessments so that we can evaluate certain criteria overtime and compared to other locations. However, in addition to…
-
Sharing with someone who doesn't have a Smartsheet account
Hi all, I would like to share a few sheets with my clients and give them access to edit the sheets. My clients do not want to sign up for a paid account and instead signed up for a free 30-day trial. Our project will run longer than 30 days, so is a paid account their only option? I'm currently on a team plan.
-
How to turn on Contacts when imported from Excel
I imported a list of 200 names, all known to Smartsheet, from Excel, into a column. The names show up as text values. I changed the column format to be "Contact" but the names are still text. If I type the name into the column, it activates as a Contact. I need a way to activate the other 199 names without having to type…
-
Milestones
Hi there! From what I understand with smartsheets, a milestone must have a start date and 0 duration. In the attached example, the arrowed tasks take a number of days to complete. However, I want to highlight these tasks as a milestone but also display the time it takes to complete them. How would I go about doing this?…
-
JC or DPH Audit findings transfer from website to Smartsheet
Good evening, at the suggestion of the SS tech support I am putting a question out here to see if someone else has solved this conundrum. We would like to be able to track our JC and DPH findings, closure and sustainment for audit findings in SS, but are having difficulties transferring the information from the web to SS.…