-
Formula to check box on header row if any rows nested under it have a specific owner/assigned to
Hello, I am trying to work out if the following scenario is possible. I have a bunch of parent tasks / child tasks. I have these child tasks feeding into a report/dashboard IF the assigned to is "Client" and want to include the headers where appropriate (ex. I don't want to pull through ALL the header rows on the sheet ifโฆ
-
sum of hours based on weeknumber
I have project hours and dates and this summary formula works well: =SUMIF(PressDate:PressDate, TODAY(), (PressHours:PressHours)) I also have a weeknumber formula on the sheet =weeknumber(PressDate@row) for the weeknumber of the press date and on the summary =WEEKNUMBER(TODAY()) to calculate the weeknumber based on today .โฆ
-
Formula that ignores blank dates
I have 4 date fields, Target Start, Actual Start, Target End, and Actual End. I need to turn the cell yellow if the date is out of sync but handle that some dates can be blank or equal. โข I may have a Target Start date, but not have an Actual Start date, Target End date, or Actual End date yet - which is OK and should notโฆ
-
Can a Workflow Cancel a Remaining Requests for Update if 1 of 3 people update?
I have a use case where we dont want to use request for approval because it writes an additional column to the sheet, we are currently using Request for Update to utilize the row form to assign a project task. When a row is created, it sends a request for update to assign a task to three people. Once one person completesโฆ
-
Task Health Formula - Color Ball
In our project plans we have child level task health and then parent level task health in the same column, indicated by a color ball. Previously, we had separate formulas for each level, but I have been working with Pro Desk to implement a formula that will work for all levels and can be a column formula. We are so closeโฆ
-
Using IF, COUNTIFS, and HAS functions to locate double booked equipment
Hello! I am using this formula in a checkbox "helper" column. =IF(COUNTIFS(Resources:Resources, HAS(@cell, "Gray Van"), [Start Date]:[Start Date], @cell <= [End Date]@row, [End Date]:[End Date], @cell >= [Start Date]@row) > 1, 1) My hope would be if a piece of equipment is selected in the Resources (dropdown) column in twoโฆ
-
permissions
Hello. I need help. I want to prevent anyone other than assigned to, which is assigned to a row in the created sheet, from taking any action. I don't want a locked row to be changed by any user allowed in the sheet. In other words, everyone can take action for the part that is assigned to in the line.How can i solve this.
-
Help! Checking a Box depending on matching information from other sheets
Hi there! I'm hoping you can help me solve a problem which I'm having trouble getting my head around. We have two sheets: 1 - School Invoices Sheets, with columns: a) 'School Name' (Text column) b) 'Type of Invoice' (with drop down options: '[1st] Pre-Delivery' and '[2nd] Delivery' c) '[Check 3] Approved' (This is a checkโฆ
-
Formula for %Complete Column (or progress bar) for 5+ Checkboxes columns
Hi! I am looking for a formula to either give a percentage complete or similiar from a number of checkboxes. I have tried; =COUNTIFS([T1]@row1]:[T7]@row1],=1) - results in UNPARSEABLE =COUNTIF([T1]2:[T7]2, "True") / COUNT([T1]2:[T7]2) = 0 =COUNTIF([T1]2:[T7]2) / COUNT([T1]2:[T7]2) = incorrect argument set
-
Project Budget/Forecast sheet
Hi all, I am trying to recreate a much simplified version of a Project Budget/Forecasting sheet that I have previously used. I have done a mock up of how this sheet could look (which is copied from the more complex version I have previously used). I have attempted to recreate this and get it working but I am not sure whatโฆ