-
Countifs using iferror or iserror
Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've beenโฆ
-
Sums, IF statements and parent rows -- combined in one formula
I'm struggling to figure out how to combine two formulas. Context: my team doesn't like to think in hours, just general size of a task (S, M, L,) so I've created a helper column where each value relates to a number (XS = 1, S = 2, M = 4, L = 8, XL = 16), and an IF statement to return the values. This formula works fine inโฆ
-
Formula Help
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values onย a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,โฆ
-
Formula help for my dashboard
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to selectโฆ
-
Finding duplicates in a column with multiple product #'s
Hi, Is there a way to find duplicates when a column may contain multiple product numbers which are comma separated? I was able to get the below formula to flag red when only one event number is duplicated in a one to one ratio, and also have the formula disregard blanks. Any ideas if there is a way to find duplicates whenโฆ
-
Trouble with formulas not applying to new info coming from forms
I created a form to capture data into a sheet. i have the form sending new info to the bottom of the form. when the data comes in from the form it puts the rows below the formulas, so the formulas are not applied. It's a sum formula, so i need it to capture the total amount of totals coming in from the form. how do i getโฆ
-
How to track items that are completed after their due date
Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an taskย was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. =IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)โฆ
-
Date cell is not calculating correctly
I have a sheet where I want to add 30-days to another cell that is a date. I am using the formula: =(original date cell)ย + 30 Example: The original cell has a date of 3/19/19. I should get 4/18/19. However, I'm getting 3/19/1930. I have cleared the cell contents, deleted the row, and whatever else I can to create a cleanโฆ
-
Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero inโฆ
-
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis