We have a sheet that represents a cross functional project plan (1000+ lines) that we want to limit access to in order to protect the information included in the plan. We've also created individual fu…
I have a dashboard report set up in card view, yet it opens for other users in grid view. How can I set the default so it opens for all users in card view? Note: the report includes filters by functio…
I have a column with Rank values on a sheet with data imported from Excel. The rank value includes an apostrophe in front of the number. What is the specific formula I need to use based on the example…
I used Save as New to copy a project sheet to a new project with the same individuals on the project team. On the new sheet, the contact list isn't fully populated, and for some contacts, the name is …
Is there a way to create a query that can be accessed via a dashboard to return data from a set of sheets? Here is my use case: Sheet 1 includes customer profile and demographic data Sheet 2 includes …
I am trying to automatically bring over a row of data from one sheet to another. Here is my use case: Sheet A is used to enter new client engagements as the deals are accepted by the client. Sheet B i…
Working a project plan and looking for a logical formula to color code the Status column: Highlight/Color code the Status field if the start date is in the past and the status is "To be Initiated", or…
If a free user has access to a report as an editor, and has commenter rights on the sheet, will they be able to make updates to unlocked fields in the report?
Hi, We have a gantt view that is showing two different colors in the view and we would like to have the timelines display in one consistent color. Can this be changed? Thanks