-
Report using multiple sheets
Hi...I would like to build a report from 2 sheets. Taking most of the columns/rows from the first sheet "Summary View" and then just one column of data for the color the RYGB color status from the "SP Automation -Internal" sheet. I have tried to add this missing data point into the "Summary View" sheet but I am at the max…
-
Send a link to a report to users that have tasks due that day
I'm not sure what the best work flow is for this but here is my current setup: * I have a task list with all tasks for the duration of a project. * I have reports that list all tasks due within the next day or week for the "current user" * Currently users get alerts for every task that is due on that day (multiple alerts /…
-
Reporting/view - A3
Hello, Has anyone created a view or report which mimics the look and feel of A3 documents popularized at Toyota? Thanks! Mark
-
Report: Date range of 30-90 days
Hello, I couldn't seem to find anything on this. I'm trying to run a report to find things with an end date between 30-90 days. I see that I can choose 'not' in the next 30 days, but I can't choose 'not' in the next 30 days AND within the next 90 days. Any creative workarounds here?
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
Insert Image Into Report Cell
Now that it is possible to insert an image directly into a Sheet cell, can this functionality be extended to a Report, so that the image gets inserted onto the underlying Sheet cell?
-
RYG symbols return date in different column
Okay so I'm almost done with my project but I ran into a snag and needed some advice. Basically what I'm trying to do is that when I pick the Green symbol todays date is input into the date column, Yellow = todays date in MISC column and leaves the previous date in the Date column. I've programmed for the green but every…
-
Quickest way to update a recurring report's filters
I have a report that I update each week. the "When" section has 7 or 8 lines where the between dates need to be updated. Is there a way to automate this or does it really have to be done manually? Thanks for your input! Jennie
-
Managing Multiple Audit Sheets
I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants,…
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",…