Reporting
Discussion List
-
Blank ReportIn Using SmartsheetI shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data? I tried sending a link to the report as well. Still nothing in the report. The customer setup a username and password. Im…
-
Rich Formatting On "Summary Sheet"In Formulas and FunctionsI'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from mul…Answered - Pending Review 11 views 2 comments 0 points Most recent by GabeHarris Formulas and Functions
-
Disregarding N/A in FormulaIn Formulas and FunctionsHi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Sum…Answered - Pending Review 24 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Adding a report to a dashboard with a "Calendar" view vs "Grid" viewIn Using SmartsheetHi - I'm trying to add a "Team Vacation Planner" to a Dashboard with a "Calendar" view vs a "Grid" view. No matter what I do, I still get the report in the "Grid" view. Any ideas?? Thanks in advanc…
-
Printing Grouped ReportsIn Using SmartsheetI have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is th…
-
Dropdowns in a dashboard, is it possible?In Using SmartsheetI have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
-
How to Alter the "Sheet - IT Ticket Metrics"In Formulas and FunctionsI want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt…
-
CONTAINS with Trigger SearchIn Formulas and FunctionsHi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device …Answered - Pending Review 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula to find the average word used in a columnIn Formulas and FunctionsHi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Merge 2 column names from separate sheets into one in a single reportIn Using SmartsheetHi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. H…
