-
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…
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
Countif containing specific text
Hello! I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error. My formula is =COUNTIF({January Range}, FIND("Cassie", @cell, > 0)) I've also tried…
-
Tracking percentage on a chart overtime
Hello! I am trying to figure out how to create a line chart that shows the updated % every time it is recorded. I know how to change the percentage complete by using formulas, but this percent is an actual percentage of a recorded number. Not a progression percentage. Is there a way for me to do this so I don't have to…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?
-
Salesforce Imports Apostrophes
This is a public service announcement... If you have an Index/Match that isn't working, and the source sheet is a data mesh or data shuttle from Salesforce, check the numeric field to make sure there isn't a leading apostrophe. The apostrophe will not appear until you click in the cell. You can rid of it with a helper…
-
Why cant I count in this date range?
Im tying to count the amount of RLO's between the dates below and am not sure why its an #incorrectargument ? =COUNTIF([RLO Receive Date]:[RLO Receive Date], >= DATE(2024,01,01) <= DATE( 2024,4,1))) Anyone help me with the syntax here?
