-
Is there a way to create a form that the data is accumulated on the main sheet?
For example: If employee A gets 200 points submitted in December and 100 points in January, on the line with Employee A, they should have a total of 300 points. Thank you for your help.
-
Count of Unique Participants in a Time Range
Hello, I am attempting to write a formula for this sheet that counts the total numbers of unique patient ID within a date range (7/1/20-6/30/21) from the "date of CM" column. Anyone know how to do that? I keep getting an error message.
-
Cross Sheet IF Statement
I'm struggling! I feel like this should be a simple formula but I'm unable to get it done. I'm referencing another sheet to bring in a name ONLY if their status in another column matches "Grandfathered". In the formula below, I'm attempting to bring in the name of an individual (Range 5) if their status (Range 6) =…
-
Trying to set a column formula without it marking blank rows!
Hello! I am running into an issue where I am trying to have the status bubble change colors based on status of the project. Red, yellow, green, gray. I have got that part figured out, but when I go to make it a column formula so that it applies to all rows, even new ones that are added, it puts the red bubble in rows that…
-
Using IF/And statements
I am running into the issue where I made a formula to flag a row if the due date is set to today or before today. But I don't know how to change it to not flag if the job has already been completed. Here is my current formula: =IF([End Date]@row <= TODAY(0), 1, 0) and here is what it is producing (below). But I don't want…
-
Blank do not Concatenate
Hello, I have a cell i use to concatenate a varying cells into one line and divides each text by dashes. Currently i'm using =column1@row + "-" column2@ow + "-" +column2@row Is there a way to spin the isblank( or if(blank formula so that if all columns 1 2 or 3 cells are blank it would not use the formula so that the…
-
CountIf formula is giving inconsistent results
I'm trying to replicate the =CountIf formula that works well in one sheet that resides in workspace A. I copied the report from A to workspace B. The formulas didn't copy over the same, lost the reference. Both reports pull from different project plan sheets but the Assigned column is the same in both plans. I am open to…
-
Formula needed to fill a cell if a word is contained as part of another cell
I have a column named Assigned Staff that is a drop down with staff names. ex. Mike Duplay and Amanda Perry. I have another column named Assigned Amanda. I need Assigned Amanda column to auto fill the word Amanda Perry if (her name) is contained in Assigned Staff. The issue Im running into is if Mike Duplay and Amanda…
-
Referencing Another Sheet
I am entering data (BC23-111) in red block, and trying to reference another sheet to pull back the file name when there is a match of BC23-111. I keep getting a #UNPARSEABLE error message. I feel like I am close but cannot seem to get past this error. Any/all assistance is appreciated, thanks.
-
Formula for parent, child, grandchild auto add rows
I am building a spreadsheet for our new hire onboarding and IT checklists. When I add a new name I would like it to auto populate children underneath it. See my screenshots below. Row 7 (Parent) - Dark blue would be the start date for new employees Row 8 (Child) - Light blue would be the individual employees (we normally…
