-
Multi Project Milestone Report
I have a series of projects that I need to report out the End Date for each of the milestones and I'd like to do that in a table. So here is what I have. I have 7 projects, each with 7 Milestones, each with 1 dates. I laid those out in a report as 3 separate columns - Project, Milestone, Date. So what I need a table with…
-
Row print
I can't find a discussion that covers this: I know there's a way to print a single row with columns in vertical view, with the option to include hidden columns, but is there a way to automatically exclude printing blank columns? I have columns that don't apply to all rows, so when printing there are blank lines. I could…
-
combining formula to round a sum
I'd like to know if I can combine the two following formulas in some way so that I only need one column: In the first below, I'm calculating the average number of minutes an editor spends on each page of a document. But, because I don't want to report the number with such precision, I have a second column with a formula to…
-
Template Sheet With a Deadline Column
Hi there everyone! I wanted to ask if there is a tamplate with deadline dates. Where we work we send tasks to our drafters with 3days of work, some times they can end the task on 5days. And we wanted to track the total of days we gave them to work with and the dates they used to work on that task. Can someone help with…
-
Highlight Changes Viewable on Ipad
Is it possible for an ipad user to see the highlights of when a cell changed?
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Date Formula to exclude weekends
Hi Friends, I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday. I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday. Hope this make sense?
-
How do I remove the Share property to a Sheet that I've saved as a back up?
How can remove all references to a sheet? Here's a summary of what I've tried. * Sheet A is my Master on which I have many project tasks out to various resources. * I made a backup of Sheet A and called it Sheet B. * I then deleted a lot of tasks from Sheet A knowing that I had them saved in Sheet B. * I removed sharing on…
-
Managing large number of filters
I manage product releases and have multiple columns that I need to filter by (department and owner). I have a variety of entries in a given column, but I cannot find a way to click the dropdown at the top of the column and select one of the values within that column (like how filter works in Excel). Am I forced to create a…
-
Gantt Chart sum of days for subtasks
Hello everyone, We're using gantt charts to planify our tasks. When creating task groups and sub-tasks, the number of days displayed in the task group does not reflect the actual number of days planned but the time span from the beginning of the first task to the end of the last task. This creates confusion when presenting…