Reporting
Discussion List
-
Count Netdays if Project Status is "Complete"In Formulas and FunctionsHello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date&q…
-
View if sheet is referenced in a report or dashboard?In Using SmartsheetI am cleaning up the numerous sheets I've created. However, how can I see if the sheet is referenced in a report, dashboard, other? I do not want to delete a sheet that is in use.
-
How do I get Summary Totals to appear on the pdf attachment?In Using SmartsheetI love the enhanced report features with the grouping and summary totals. But when I send this as an attachment, they disappear? Is there a way to print and save the report to an attachment so that it presents the designed view? Thanks f…Answered - Pending Review 25 views 7 comments 0 points Most recent by Michelle Culmore Using Smartsheet
-
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…Answered - Pending Review 829 views 23 comments 6 points Most recent by Michelle Culmore Using Smartsheet
-
Rolling 12-months formula: % of projects completed on timeIn Formulas and FunctionsI am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-mont…Answered - Pending Review 149 views 5 comments 0 points Most recent by MCorbin Formulas and Functions
-
How to capture time elements from a form and display on a dashboard.In Formulas and FunctionsGood morning Experts, I have a particular set of data that is tracking productivity with a time element reported as (hour):(minutes) AM or PM I am gathering the data in a form using text/number. Once in the sheet/grid I cannot figure out …Answered - Pending Review 21 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Sheet Summary CountIFS + Date RangeIn Formulas and FunctionsHi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was converted over from Google Form/Sh…
-
Index/Match Formula - No Match to show BlankIn Formulas and FunctionsI've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put t…
-
Show top 10 schools on dashboard based on number of active students at each in datasheetIn Using SmartsheetBeen playing around for a while and haven't been able to sort....I have a datasheet with a bunch of data associated with a list of students, including the school they attend and whether they are currently active, graduated etc. I am looki…
-
Gannt Chart in DashboardIn Using SmartsheetI have a dashboard that I've created that is pulling in a report that looks at key activities and dates from a project plan. It is a Gannt chart so users can get the visual of the project status. The problem I'm running into is that the…
