-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
-
Predecessor Content Change in Report?
Recently I have noticed that what is displayed in the predecessor column when running a report has changed from showing the specific line dependencies to now just showing the number of predecessors ( i.e., 1 Predecessor, or 2 Predecessors). This isn't really of value when looking at a report. Is there a way to show the…
-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Building a report based on the calendar, and I need to use "YESTERDAY"
I'm building a report that will show things that are happening TODAY and in the FUTURE. I can build each of those separately, but together seems to be an issue. I built a filter based upon date being YESTERDAY, but when I go back to check it, it has placed the actual date in the field. Is there a more permanent solution to…
-
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
-
Automated linking of added rows
Hi! I seem to have a major problem here and hope for you expert advice. My situation is as follows: 1. Team A and team B work collaboratively in Masterfile on first phase of the project with over 200 rows from all countries. 2. Team A also works with the other 7 country teams on a second phase of the project. 3. All teams…
-
Split Screen for scrolling on Reports used in Dashboards
It would be helpful if you could scroll through the Gantt view of a report, separately from the Task view, when looking at a report that is embedded within a Dashboard. Today, there is only a single horizontal scrollbar and you can quickly lose sight of the associated tasks as you scroll to the right to see everything in…
-
Report on Previous Entries
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5% change as a percentage, or even an icon on a sight. Can this be done natively through the changelog, or would I have to…
-
Question: Formula results in reports
Hi! We use formulas in sheets. When will the calculation be done? Ony when having a sheet open? Or also when using the column in a report? In other words: If the formular uses TODAY or s.th. like that, the result differs from day to day. But is the result okay, when the sheet hasn´t been opened for a few days, but used in…