-
Pivot: when more than 1 variables in columns?
Current design of Pivots allows to have up to 4 variables in Pivot table rows, but only 1 in columns. Will it be possible to enter more than 1 variable in columns? When? Thank you
-
Question about the Resource Allocation Feature
My team has a master project list for the year. Some of the projects include ongoing projects (newsletters, web maintenance) that we marked as a due date of 12/31/19. Others may take a week or a month. When I turned on the resource allocation tool, I noticed that everyone was majorly over allocated. Would the ongoing…
-
Report access without sheet access
I have a sheet with a lot of information I want a particular person to be able to access a subset of that information. I therefore created a report which includes exactly what i want them to be able to see. I tested sending a link to the report to an external address but when i log in as that external user all i see is a…
-
Data Values Not Scaling
Can't figure out what I'm doing wrong. The horizontal axis won't let me scale to data values - option is grayed out so all the values are pushed to the top. In the first column the 86 should be in the blue, the 7 is for the red and the 30 should be in the orange. The vertical axis allows for scaling but it doesn't do…
-
reporting on update requests
Hi all, Every week I send out update requests. I get the notifications when someone makes a change but I was wondering if there is a way to actually report on the update requests sent out and which have actually been done vs those that have not been complete???
-
Automation, Reports and Projects
Hello, I'm trying to find a way to automate my Reports. I want to create a Report that uses an entire folder under Data. So that when I add a new sheet to that Folder the Report automatically updates and I don't have to modify the Report after every new sheet. Another automation I would like to do is create a site…
-
Sales Formulas- Revenue by month and deal total by month
HI everyone, I am trying to create three formulas on a sales pipeline. The first is I am trying to track for the month of July how many deals we have that are opportunities. Then I am trying to track for the month of July how much revenue in deals we have that are in the opportunity stage. I then want to be able to track…
-
Auditing Workspace Permission Changes
Is there a way to audit what changes were made and by whom for a Workspace? The activity log feature seems to only apply to sheets, dashboards, etc. Use Case: Permissions to a workspace have changes. I want to know who made the changes and when.
-
Report Developing - Removing "Header" task
Hello all, I am trying to see if there is a way to remove those "header" tasks from reports. I ask this because it captures dates from the sub tasks and therefore becomes duplicative in a report. I have colored these lines so its easy to overlook them now but it would be lovely to have a way to remove them completely. For…
-
Resource Viewing in Calendar View
Good afternoon We have resources that we have assigned to tasks for the next few months, booked out. How are we able to see our resources in calendar view?