-
Creating multiple graphs in a dashboard from one report or source sheet
I feel like I'm missing something - using only core applications, is there a way to create multiple charts in a dashboard for ongoing data (meaning every time a row is added I want the graph to be fluid to update accordingly from one report?) My understanding is if I'm selecting from the source sheet, its stagnant data and…
-
Why would a user that has edit-can share permissions on a report not be able to update filter?
I have given edit-can share and shared to report only permissions to a user of my report with the hopes they would be able to update the filters temporarily but they are unable to do so, when they hover over the is between date they get an x icon and cannot click it. I ran through the other permissions even up to admin…
-
WorkApp Comment: No Red dots showing for new added comments
We built a Workapp portal for our clients with edit access on the reports only (no sheet level access was given to any of our clients for security purposes). Now, I'd like to know why there's no red dots showing for new added comments when they're working at a report level housed inside the WorkApp. It's not helping our…
-
Building a Dashboard off of my Status column
So I am want to build a dashboard that will track/show how many complete, not started, and in progress tasks I have. I have four separate sheets that I will be doing this with. Each having about 8-12 tasks that will be tracked. The problem is which I will share below is under each "Task" I have a Indent where committees…
-
How to set up recurring task schedule for Payroll team?
Hello all! My company's Payroll team is seeking a task management solution to help them track recurring to-do's related to payroll processing. We are on a 24 period pay cycle (15th and last) and there are some tasks that need to happen every cycle, some that happen periodically or annually, as well as one-offs. They'd like…
-
Merged: Allow the Report in Gannt View on Dashboard to display complete bar darker than not complet…
This discussion has been merged.
-
how to make all (not one by one) complete bar darker than not complete bar on report?
Does anyone know how to make all (not one by one) of the percent complete portion of the bar so it's darker than the % not complete bar? It's really confusing the way it pops up. I've tried to change several conditional formatting settings and no dice.
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the…
-
Combine "AND and "OR" with filtering
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
-
Workaround to sort Report rows manually?
Anyone have a workaround solution to sort Report rows manually? For example, we need to put priority items at the top - but that priority is manually adjusted (not logical). Using a 'Priority' column to sort by doesn't work, because they want to move around and see how it's adjusted without having to save and refresh the…
