-
Row Report: Only show if all sheets are present
I have a row report that grabs data from two sheets. Everything gets Grouped by a primary identifier. Because the two sheets are generated at different times (think a multi-stage form), I'd prefer to only show the data if both sheets are present. However, I cannot figure out how to use filters to do this. Any advice?
-
Form Reports
Hello, We are using a form to track a task. The user responsible for completing the requests on the form receives an email notification to take action. Is it possible for a summary report to be sent out on a regular cadence so that the user can make sure he/she did not miss an email notification? If so, how is that setup?…
-
Return a string value if cell is under, over, and between certain values (IF) function
I'm trying to get an IF function to work in the Health column of my sheet using the following logic: If budget used cell is less than or equal to 74, return "GREEN" If budget used cell is between 75 and 100, return "ORANGE" If budget used cell is greater than or equal to 100, return "RED" I am using the below function:…
-
Parent Row Only Report
Is there a way to build a report consisting of only parent row information? I am trying to show overarching HR Processes in my sheet (parent row) without pulling in the sub-tasks. I tried a checkbox report but the sub-tasks are still showing up in the report although they were not selected. Perhaps there is a workaround or…
-
Dashboard - how to change Metric Widget data source after time of creation
How do i change the data source of a metric widget? You can 'add data' but this adds a new one. In my particular use case we can now copy and paste widgets between dashboards, however this is no way to edit the data, ie use the widget as a template. For me, we have a standard project template, and want a standard dashboard…
-
Date Modified
I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific date. I have a Report that uses the 'is greater than-date modified' but I get results from all…
-
Report showing Jira hierarchy
We've setup the Jira connector and sheet indenting is correct. How can we have the same hierarchy setup in reports? When I group by epic all subtasks fall off... I don't see the option to group by Category which is available from other reports. Thank you!
-
Looking for some suggestions to a reporting challenge I am facing
My team currently uses a vertically formatted sheet as a Project Management Schedule. Using Gantt charts, we track tasks and milestones in rows vs columns. Of course, now, I'm being asked to report on that vertical data in a horizontally formatted report and I'm struggling to figure out the best way to do that in an…
-
Remove users from Sending a Report as an Attachment
Hi I have created a report and am "Sending it as an Attachment" to myself and three other users. Two of them are "free users". I'm trying to remove myself and one other user from the Sending as Attachment but our names are greyed out. How can I remove the two recipients from the distribution list?
-
Reporting Columns
Dear SS Team, I noticed that Reporting function sorts the reporting columns in alphabetical order rather then the column order in that particular sheet. Is there a way to disable this sorting and keep the column order while choosing which data to be reported? I am sure you will understand better from the Screen Shots.…