-
How do I sort by due date in a report?
Is there a way that once I have grouped in the primary data in a report I could sort by due date in that report? I have grouped the primary column and then summarized the start and due dates, but would then like to sort by the due date so the "Project-Interviewee#" and "Interview Name" is sorted in descending order by the…
-
How to limit dropdown list values to only be selected once per sheet
I am trying to figure out if it is possible to create a dropdown list and then enforce that each of the potential values could only be selected once per sheet. For example: I have a sheet with two columns. Project Name and Project Priority. Project Priority is a dropdown list with preset values. If I select the Project…
-
How can I create a link in multiple cells simultaneously?
Hello, I want to link a cell in one sheet to multiple cells in another sheet. The source cell contains a date, and I need that date to be linked to multiple cells (all in the same column) in another sheet. I've tried highlighting multiple cells in the destination sheet and using Paste Special -> Links to copied cells, but…
-
Formula for Modified Date
Hello, I want to keep track of End Date changes on workstream plans. Aware the automated Modified Date column is updated following any change to that row. I want to find a way to populate a Changes Log with specific information from a row, if the End Date Column has been updated. Unfortunately, the layout of the activity…
-
Can I auto-populate a cell with available license numbers listed in another column, sheet or report
We share license numbers and they are issued manually now. The process is, we look at the required dates, usually about three weeks, then look to see which license numbers are not in use during those dates and manually assign it. We would like to automatically assign it with a number not in use during the required dates.
-
Build Report that shows "Child" lines items under the "Parent
I am trying to build a report from a sheet that has a parent line item with child line items. I need the report to show the parent and the child. Then have the ability to group by the parent. When the parent is expanded it shows the children. My report currently looks like this...all the indented child line items are no…
-
I need help with a SUMIFS formula to calculate total hours for an assignee based on dates
I'm working with a sheet that has a start date and due date, a column for assignee name, and a column for Hours/Week they're working on a project. I'm trying to get a formula to calculate the total hours an assignee is working throughout the sheet between two dates. I'm currently trying the formula below but it's brining…
-
Auto-populate project phase in another sheet
Hope someone can help me with this question.... I would like to auto-populate a project phase (i.e. initiate, plan, execute, monitor&control, close) in another sheet based on completion of phase in project schedule. In essence, when 100% of the tasks are completed for a phase (let's say plan) in the schedule, i would like…
-
Tracking Previous Week Order Completions vs This Week
Hello, This feels like a simple question, but the answer is eluding me. We have dates getting automatically logged for when orders come in/are delivered, and then another automation to log the date when the inspection is completed. I need to have two different results. One for when an order delivered from the previous week…
-
DATES FORMULA
I'm trying to create a formula for the below information: find if in a range of start dates and end dates of a specific job, one or more of these dates correspond to the current week date if that's happen the guy is not available otherwise is available for this week thanks
