Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?In Using SmartsheetIn other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…Answered - Pending Review 15 views 3 comments 0 points Most recent by Scott Rapoport Using Smartsheet
-
Is it possible to change who an automation is sent from?In Formulas and FunctionsWe have an automation in place to notify an employee when they have received a nomination. That nomination is submitted via a form by another employee but we do not want the employee that has been nominated to know who submitted the nomin…
-
Date comparison, if greater than 30 then flagIn Formulas and FunctionsHello, I have two date columns that I would like to compare. The first column is named Requested and the second column is named [Sign off on]. In a third column formatted for symbols is where I've written the following formula, =IF([SIGN O…
-
Average If using a list rather than a rangeIn Formulas and FunctionsI need to take an average if the data is greater than zero. I got it covered when the data is neatly organized in a range: =AVERAGEIF([Chart Data]79:[Chart Data]82, >0, [Chart Data]79:[Chart Data]82). My issue comes in when I try the …
-
Formula Looking at 2 DatesIn Formulas and FunctionsHi! I'm working to track whether or not the need by date entered on request forms abide by our 7-business day SLA. The goal is to see out of the requests that were not completed by the need by date, how many of those requests were outside …Answered - Pending Review 11 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Company Dashboard ExamplesIn Using SmartsheetI have created some dashboards for each department in our company and I'd like to create a company dashboard where you could see a company overview with a link to each dashboard and to department info. Would anyone be willing to share ima…
-
Smart Sheet Super user charactisticsIn Using SmartsheetWhat personal characteristics do you look for when selecting Smartsheet Super Users for your organization? For example: Critical thinking skills
-
Charts in DashboardIn Using SmartsheetHello- Has anyone had any issues with not all of their data selected for the chart actually showing up within their selected graph within their dashboard?
-
Smartsheet DashboardsIn Using SmartsheetHi! Is there going to be anyway that you can download Smartsheet reports instead of having to "print" them one by one if you have a bunch of them? Thank you! Jenna
-
Report Sheet Name Column Format InconsistentIn Formulas and FunctionsI'm finding when I build a report for a collection of sheets or a workspace, the formatting of the Sheet Name column is inconsistent from line to line. I have the report grouped by Project Name with the information coming from a workspace …Answered - Pending Review 10 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
