-
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
-
Permission to view a report in one Workspace that points to a sheet in another Workspace
I would like to create a report in a Workspace that is view only to a group in that Workspace, and have this report pulled from a sheet in another Workspace that this Group would not be allowed to view. This does not seem to work, as the Group permissions don't allow this report to be run since this group is not allowed to…
-
planned versus actual
Is there a way to track what hours are actually spent on a task in relation to the hours that were planned?
-
Count Info Across Multiple Sheets
Howdy! I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and…
-
statistics on multi projetcs
Hello, I am working on many project and my boss want me to say which task is finish in advance, in time or late compare to the initial date calculated. ex: when the project is finished we want to know which tasks are good and which are wrong. the task drawing start the 2015 01 01 and must be finish the 2015 01 30 if the…
-
Reporting - % Complete filter not working?
Tried to filter for tasks that are LESS Than 100% complete, however 100% tasks are displaying.
-
Summarize Columns in a REPORT, not a Worksheet
I've looked far and wide, and haven't found a way to summarize column data in a Report. My team uses a single "Status Tracking" Smartsheet, which has a large number of columns. For some of the columns in that worksheet, I have created Summary Rows with Count or Average Formulas, so I can determine the number of records for…
-
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
-
Report not sorting on given column
I have a report that is not sorting on the column I specified. It was working yesterday, but today it is not working. It is to-do list report that is sorted by Forced Rank. I can sort by other columns (e.g., Due Date), but for some reason the Forced Rank sorting is not working anymore. Forced Rank is a Text/Number. Forced…
-
Populating existing sheet rows through a form
I'm looking to collect weekly sales reports from a number of sales teams spread across different countries. Ideally I want the data from each weeks sales report to drop into a row (with the week number and/or week end date) in my master sheet. Some of the data in the master sheet will be pre-populated (overal…
