-
Predecessor formula
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
-
Feature Request: Static formula's for a column
My Sheets are heavly Forumula laiden and this, in itself creates an issue insofar as each time I create new rows I have to ensure all my formulas are copied from a blank row. I'd love to be able to define a formula inside a column that means that the formula is ALWAYS used whenever a new row is inserted etc.
-
Problem with Index Match
Hi I'm trying to fill out the hours with Index/Match. It works with some but not with other. Here is the formula I'm using =INDEX({Week 19}, MATCH(Matter2, {Matter}) (Image 1) Image 2 - Were data is pulling from On some it works however on other it defaults to the first one. In the 3rd Image I use the formula, =INDEX({Week…
-
RYG Formula
Good Day All: I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula: =IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date (Planned)]3, "Blue"))) Thanks
-
countif current month
I was counting for current month. However, I keep getting invalid data type. =COUNTIF({Month}, MONTH(@cell) = MONTH(TODAY()))
-
Sumif with multiple assined to
We would like to create a list of all team members and the sum of their days on task for each team member, but we are having issue when there are multiple people assigned to one task. Each name should be only once in the list with the sum of the days. The result when summing up the table of our screenshot should be Rahul 7…
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Formula for date range
I am trying to calculate the total amount of invoices, from a given contractor, within a given date range. Im not sure how to write a formula to calculate within a specific date range. I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into the formula. Here's where…
-
Using WEEKNUMBER() Formula
I'm trying to use the WEEKNUMBER() formula while calling a cell with a date in the format 07/17/19 and I keep getting an INVALID DATA TYPE error and I cannot figure out why. This is the formula in the cell: =WEEKNUMBER([Install Start Date]1) The [Install Start Date]1 displays 08/08/19 but is gathered from a VLOOKUP into…
-
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?