-
Row Report in "browse"
So I know how to create a Row Report, but I don't seem to be able to find it in "Browse" once I leave the report. I thought this would be something you could save and return back to, just like with projects and other workspaces. Am I looking in the wrong direction, am I doing something wrong or can I just not save them for…
-
User Certification Report
I am writing a Smartsheet User Certification Tracker template for each user in our organization. There are only two columns, the Certification Name and a Date column. I want to have a Report on each person that only shows Certifications for which there is a date in the date column. Is this possible?
-
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
-
Merged: Sort Rows by Count (in Reports)
This discussion has been merged.
-
Merged: Merging rows between different sheets in a report
This discussion has been merged.
-
Format report as a form; export to Word
I would like to be able to use SS as a repository for data that can then be output through a form and imported into a Word document as formatted text, using Word style assignments.
-
Is it possible to conditionally format the colors on a bar chart?
I am tracking service level across clients. In the reports I get the formulas and conditional format to work but I can't get it to translate into my charts. Is it possible?
-
Report Filter Conundrum
I want to filter out these parameters - A project has 'New Store Unchecked' and 'Survey Scope Unchecked' The problem is that when a project has New Store Checked it will always have Survey Scope unchecked so I cant filter by 'Survey Scope Checked' as 'or' in the filter because I need to see those New Stores. Is there…
-
Validation on Dates and or other data
Hello, We are trying to create a vehicle reservation form, we currently have 3 vehicles. Objective: A user submits a form to reserve one of the three vehicles. They select a date range. Click on all day or duration if it's half day. The administrator of the vehicles will then get the request and determine what's available.…
-
Color of Progress Bar in Report in Gantt View
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else seen/experienced this?