-
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?
-
Can Requested Data be Compared Against Product Available Data
I have a situation where a form request for products populates a sheet but the products requested may not be available in that market so the request is an invalid one. It would be great if, after form submission, we could compare the new row (request) against a matrix sheet of available products. Has anyone done that…
-
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…