-
Linking Summary Sheet Field Data Into an Existing Sheet to Report on Multiple Projects
Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding milestones, non-milestone status, and #of outstanding non-milestones. From there, I am…
-
Compare dates in the same row but different columns
Hi all, Im looking at counting the number of times two date columns differ within the same row For example Column 1 Column 2 11/2/20 11/2/20 11/4/20 14/11/20 11/3/20 11/3/20 25/5/20 12/6/20 In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both…
-
=(IF(AND(ISDATE INCORRECT ARGURMENT - HELP
I am gettng an Incorrect Arguement with the following formula and can't figure out how to fix it. =(IF(AND(ISDATE(Complete@row), ISDATE(TATS@row)), NETWORKDAYS(TATS@row, Complete@row) < 0, "1", NETWORKDAYS(TATS@row, Complete@row)))
-
Difficulties Nesting formula
Hello all, I think I am close to the answer here but struggling to figure out what I need to add to the formula to. Looking for the formula guru's here. Here's what I need this formula to do. I think I am on the right path, hopefully. If "Lab Date Received" row is empty, return "Awaiting FER in Lab" If "Lab Start Date" is…
-
COUNTIF multiple Criterias
Hello there, i am trying to count the number of time certain names have been selected in a multi drop down list, in a specific range of time, while referencing another sheet. I've tried the formula below and getting an error =COUNTIFS({Phase}, CONTAINS("Complete", @cell), {Go live date}, >=[Column10]@row, {Go live date},…
-
RYG "Yellow" Error for Health Metrics in Summary Row
Hi Community, I am trying to create an overall health metric for a project based on the information in the summary row of the schedule. The criteria is a mix of fields: If the Status is on Hold = Blue If the Status is Complete = Blank If the Finish date has passed = Red If Today is within 7 days of the Finish Date and %…
-
Count a number between two dates
Hi, Do you know if there is a formula that will count how many rapports were produced between given dates (20-01-01) and (20-12-31) in the Created (Date) column for the person xxx? Thanks,
-
VLOOKUP to return value
I am trying to return a value in a sheet using data from one other sheet. Look up whether there is anything entered in the 3rd column OEM License Agreement. If true then return the Company Name, column 1. This is what I wrote: =VLOOKUP({00 CF/CI OEM-Fab Agreements [MASTER] Range 4}3,{00 CF/CI OEM-Fab Agreements [MASTER]…
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
Using COUNTIF only if it qualifies...
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, {Team Movement Range 1"Donald Duck"}1). In the pic below Donald has 2 courses assigned…