-
Automate Value Recording
All, I am trying to setup a PMO dashboard where I am putting Total Portfolio Value graph. I have to update the graph fortnightly to record current value. Is there anyway to automate this function so that everytime I dont have to manually enter value.
-
Report on today and next workday
I'd like a Report that shows rows with the Date field from today or the next workday. That is on Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday Sunday - shows Sunday/Monday My sheet is very complictated and starting to visibly slow down so…
-
Feature request: Ability to use "Me" in reports
Hi Team, I think this would be an incredibly useful development that should be blindingly simple to implement - to allow reports to be created and filtered based on "Me" from a contact list column. This would simply take the loggeed on user's name, whoever that happened to be, rather than selecitng a specific contact from…
-
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…
