Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
Hi, I have a sheet with two date columns. I want to count the rows where only one of the date columns have a value. I´ve tried to create a third column with a formula that sets it to 0 or 1 depending …
Hi, I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tri…
Hello, We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification…
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some dat…
Hi I am trying perform the COUNTIFS function and can't get this to work. So what I need to count is the following * Count if criteria is "s" in the function column * Count if criteria is "Med" in the …
I'm trying to set the RYG status of a task based on End Date and % Complete of the task. I've put a formula in place using =IF(AND(... but I keep getting the error "# INCOMPLETE ARGUMENT SET" Below is…
Hello, I'm trying to minus days from dates using the following formulas but am getting errors everytime: =NETWORKDAY([Date Printed]8 - [Date Dispatched]8) - gives me the error #Incorrect Argument Set …
I think I'm close but this is driving me crazy. I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday. I would like to know the total partic…
I folks. I think I found an edge-case in your new cross-sheet formula system. I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was w…