-
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
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
Calculating percentage based on status options across multiple columns
I am trying to average the sum across multiple columns. Each column is a single select dropdown that will allow the user to choose from the following options: ⦸ (Not applicable) ◷ (in progress) ✓ (Complete) I want to assign values to these symbols. ⦸ = 1 ◷ = 0.5 ✓ = 1 I have only been able to get the following formula to…
-
Filtering by a Summary sheet field in a Row Report
I am trying to create a report that will include not completed tasks from all my projects with a due date either 5 days in the past or 5 days in the future. This way I can look at it and either get updates or make sure the resources are working on the tasks due soon. However, I have cancelled projects in my workspace that…
