-
How do I display a different symbol based on multiple values?
I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work. I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display. Scenario: 0% = Green 1% - 10% = Yellow 11% and over = Red This is the formula I'm currently using. I get the Green…
-
Send report as attachment in Excel format without comments
Hi, I would like to send a report in Excel format, but do not want the comments to be visible to recipient. Currently they are on a separate tab. Rgds Warren
-
Reports not sorting by assignee?
Does anyone else have issues with newly created reports not sorting by Assignee? I am perplexed, have initiated the sort order to be by assignee and nothing happens. Can someone please confirm I am not just seeing a photographic memory of the report before it was sorted?
-
Send Daily Report only when data changes on underlying sheet
How do we send a report only when there are sheet changes. At the moment report is set to a filter where modified field is today. But if nothing is changed a blank report is sent. How do we program so the report is only sent if there is data?
-
I would like a chart in a dashboard show the sum value in the summary line of a report
Hi everyone. I have reached the max on a sheet leaving me to archive it and creating a new one. Once I have done this, I want both sheets on my report and from there sum the values and then portray that value in a chart on a dashboard. Currently the dashboard shows the chart from each sheet, not the sum of both sheets. How…
-
Status Report / Table
Hello, I am stuck with piecing together what I thought would be a simple visualisation. I'm trying to build a report to go into a dashboard that shows the status of various projects in a table like this: I need the columns across the top to run left to right in a specific order and beneath that I want my Project Names to…
-
DynamicView and reports with groups
Anyone have ideas about how to use DynamicView to show column summaries as we now can in a report?
-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
No Title for Second Column Selected in Chart on Dashboard
Hi Everyone, Thanks for your help. I've got a few spreadsheets with data collected, and I'm trying to make a chart on a dashboard. I'm very comfortable in Excel, but for some reason I can't get the title for the second column to read in my charts. I have flipped back and forth between "Switch Rows/Columns" and that doesn't…