-
Consolodating multiple sheet info onto a single report line
hi I run a smartsheet where users create smartsheet sheets to plan individual projects. I have a list of all the sheets required. I want to pull a report that compares the list of sheets required with the sheets actually created to track progress. I can create a report which pulls them in as pairs of rows (1 line from…
-
Report error with RYGG Ball column
Hello! I have a report pulling from eight different sheets, and there is one line that is appearing that does not match the report criteria. It has been this way for weeks; I assumed there was a glitch in the system that would be worked out. The criteria is as follows: - "Status" column (RYGG Ball) is blank AND - "Due…
-
Export feature got worse since SS upgrade
One of the nice features of SS was the option of including the comments when exporting say to Excel. The exported file has all the comments in a seperate Excel tab. But it still referenced the "Primary" so you can match each row in your SS (1st tab in the Excel export) with the comments. A few weeks ago, there was an…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
Linking cells from multiple sheets to a report
Let me describe what we're doing: We are an agency that has several creative agents working on projects for our clients. Each creative logs hours worked on projects. We need to be able to count the total hours worked by all agents, then report that to the client report in one cell. Does that make sense? So if we have 5…
-
Gantt View
Is there a smartsheet timeline for implementing the gantt chart "zoom in" to see hours/minutes of a day? I have been tasked to figure out a 24/7 schedule for 3 crews and would love to see the gantt chart reflect actual change over time....cross over...lag etc.. Also are there any plans to update the printing capabilities…
-
Reports using checkboxes
Is anyone else having issues with reports at the moment? Most of my reports are based on checkboxes (display if unchecked, don't display if unchecked). These have been working perfectly until today when all of a sudden if you check a box in a report, save and refresh the line remains on the report. I have checked numbers…
-
Hours tracking conundrum
Hello, I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one…
-
Time Tracking and Invoicing Clients
I'm trying to find the best way to track time against projects using smart sheets in a way that billable time can be easily invoiced. Ive read through many community posts, but still cannot find something that is helpful, or a smart sheet template that I think will work wel. We currently use Zoho Projects for time entry.…
-
Reports in SmartSheet
I want to create a report that summarizes information on my smartsheet. I don't want it to list individual line items. Is this possible? I am trying to mimic something I am doing in Excel with pivot tables and tables. If it's not possible - does anyone have recommendations for reporting plug ins?