-
Lookup Formula Help
I'm looking for a formula that can look at the highlighted field and only pull out the option I want. example in column 30 it will look at the highlighted column and if PLD is in there it will answer PLD and ignore everything else. The highlighted field a person can select multiple departments and I need to be able to…
-
How to get the current week Dates Dynamically
Hi there, I've created a user level Timesheet, where users have access to update their Timesheets on weekly basis. User wants to see the current week Dates.(Eg; Wk 50 "Mon 11Dec - Fri 15Dec") Please find the below screenshot for reference. I've tried using today's date formula, somehow it shows the next week dates. Is…
-
Formula to calculate percentage excluding certain value
I have a sheet that we use to track travel. I have a formula that calculates the percentage each person is traveling per quarter but also how much of our team is traveling per week. We have 14 people which is what the current formula is based off of. I need to modify this formula to exclude when someone is on vacation…
-
Multiple IF function formula not working
I am wondering why my formula is unparseable: =IF(Proof@row = "Waiting for Proof", [Proof Start Date]@row + 30), IF(Proof@row = "Family Service Rep", [Proof Start Date]@row + 14)) If my proof reads "Waiting for Proof" I'd like it to calculate a due date of 30 days from the proof start date. However, if the proof reads…
-
Formula for Duplicates by most recent
Hi there! I have a sheet that is updated daily with new information. Often times information is duplicated and I'm trying to filter that out. I have two helper columns for checkboxes. The first column is set to check the box if a duplicate is discovered. =IF(COUNTIF(Number:Number, Number@row) > 1, 1, 0) Now I am trying to…
-
Sheet summary formula becomes #unparseable upon sheet exit
Hey folks, I'm hoping you can help me solve a mystery. I have about 30 sheet summary fields all using the same formula, which counts two types of responses in each column. I copied and pasted the basic formula in every sheet summary field, then changed to the appropriate column name (the column names are spelled…
-
How to review a column of dates and count the rows that are not a date
I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example, 12/01/23 12/02/23 12/03/23 Active 12/05/23 Not Active 12/07/23 (space or blank) 12/08/23 12/09/23 12/10/23 In this example, the number of non-dates in the column should be 3. I believe I…
-
COUNTIF formula using a date column - Count number of dates in current month
Hi, I am trying to write a formula that allows me to count the number of dates that have the current month. Have tried a few formulas and the only one I can get to work is the following however; I dont get the expected number which should be 4: =COUNTIFS([Inactive Date]1:[Inactive Date]2232, ISDATE(@cell), [Inactive…
-
Struggling to String together the correct COUNTIFS
Hello There Community I need help with stringing variables together I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL"))))) Everything works up until {Airline} which is the sheet reference Essentially I want to return the count if the cell contains either AA…
-
Create a chart that shows a count of names, MoM
Hello, I have set up a sheet using calendar view that shows the name of different speakers at events each month (eg: Bob Smith is speaking on Dec 3, 6, 7,11 and on January 6 and on Feb 2, 4. Mary Jones is speaking on December 4, 5, 6 and Jan. 7,8) I would now like to chart, on a dashboard, how many times each person speaks…