-
How to count At Risk task to create a report?
Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =COUNTIF({Sheet - Request Tracker with Form Range 1}, "Flag") Thanks for your help
-
How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their…
-
Shared report not showing all sheets
Hi Everyone, I have an issue where I have a report that is combined from 9 individual engineer smartsheets. As the admin, I can see all 9 users sheets and the report looks correct. However, when I emailed the report to my other email address to check it, the report shows only my own rows (because I shared my own sheet with…
-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!
-
Pivot tables grouping
In excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?
-
Report / Dashboard - Grouping option not working
I added a grouping in a report to organize the display in a dashboard. I want to group the report by type of project and for each type of project sort by go live date. When I am in the report, the grouping works. However when I pull the report in a dashboard, the grouping is not taken into account, only the sort by go live…
-
Formulas with reports
Hi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!
-
How to Group data in a Report by Year
Hello, I have exact finish date for each project in the roadmap. But I would like to create a report that can group these projects together by year only, not by specific date, how can I do that?
-
Presenting N/A or Entering Date in Reports
Hello, We are attempting to come up with a formula that will present N/A in a Date column if the parent column lists N/A, otherwise we want the date functionality to work by presenting a calendar the user can select the date from on their individual report. What we are running into when the report is created is that the…
-
Project Plan - Manually Changing "Start Date"
Hi Team, Can anyone help me why I am not able to manually change the start date .. I want this functionality to be disable so that the user can manual change start date related to task name assigned. Please help