-
Hybrid Report/Sheet
I'd like to use Smartsheet to track performance on a multitude of projects. I can use a Report to quickly gather a list of assignments and compare Need Date to Date Completed. But I can't add any additional columns (i.e. with formulas to display graphics based on whether the assignment was completed on time) or additional…
-
Report not showing a row
I have a project plan with rows linked to a sheet. I am attempting to pull a report on this sheet, but the report is not pulling in all of the criteria. The project plan has a column titled "Tags", which has Milestone and Timeline. These tags are included on the linked cells in the other sheet. I Run the report to include…
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
Reflecting only Parent Rows (multiple) on Dashboard
For a project release, we're leveraging checkboxes to track completion of validation tasks. I have a dashboard built to reflect progress, however am having trouble finding a way to only choose the multiple Parent Rows/Roll Up data, as it's making me include child data or nothing.. (including all the child row stats will be…
-
Report Publishing...
I want to be able to publish a report link for editors to update a project status the way I can publish fully editable links via the sheet itself. Why can I only publish secure links for reports that require a login? I want editors to have access to change information in a report without logging in. What am I missing?
-
Sharing Reports
I support a team of graphic designers and I created a report showing them all their projects and tasks. I thought the designers would be able to sort the reports by date, sheet name, % complete, etc, as they need to to organize their workload. But I'm finding out that they are not able to do this even though they have…
-
Auto Populating Report or Sheet with New Rows from Master Sheet
Hello- I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet. For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project…
-
Limitation Perhaps ? - Number of rows visible on the report on a dashboard
I have a Gant chart going to track all my sprints and have a report reading of the same which shows up all sprints and tasks. Presently the number of tasks in my Gant and Report exceed 200 already. However the report which is embedded in my dashboard allows me to see only upto a max of 150 rows after which it shows up this…
-
IFRAME - load with Fullscreen option
I'm embedding several reports / dashboards into a sharepoint instance and I would like to have them load in full screen by default. I am referring to the Normal View Vs the Full Screen View that can be achived by clicking the appropriate icon on the bottom left of the embedded frame. Please help! Thanks