-
#INVALID DATA TYPE error on NETDAYS function
I am trying to find the number of days between two dates - a due date, and a paid date. I used the formula =NETDAYS([Due Date]@row, [Cleared Date]@row). This worked for a good chunk of the cells, but not others. The remaining cells are returning the #INVALID DATA TYPE error. I've already ensured both the Due Date row and…
-
Count dates and another column
Hi, I am trying to check a dated to see if its week 1, week 2 etc and then count the total from another column. A formula that would look up column "date" to see if the date range is within project calendar week (1,2,3 etc) and then total the number of hours within that date range. hope someone can help ;)
-
Form URL - Manipulate Header/Help Text
I know that we can use formulas to generate URLs that will allow us to auto-fill certain fields within the form using row data. I also know that we can use this to automatically check the box to request a copy of the form submission and that we can use this method to auto-fill the person's email address. What I would love…
-
Join Multiple Contacts in one Cell based on Contacts in Multi-Select Cell
Hello Community, Thank you for you assistance in advanced. I will provide you the end result ahead of the post in hopes that it can spark an idea that I might not have thought of before. Required Solution: Join multiple Managers (contacts) into one single cell based on a list Team Members (contacts) from another one single…
-
How to get a sum total of columns with names into another sheet with a different name?
I would like to know how to get a sum of columns with heading in a row from sheet A to be populated in a column in Sheet B when a status has been changed
-
How to insert/delete a row that is in between two rows that have links to another sheet?
I am working on a project with a "customer view" that links to the "master sheet". When a customer fills out information into their sheet, the information is linked/filled into the master sheet using the linking process. I am trying to figure out how to add a row in between or delete if necessary without changing the…
-
Help Using JOIN(COLLECT
Hello, I have used the following formula to collect values from a source sheet into a target sheet: =JOIN(COLLECT({Deviation#}, {Batch}, Batch@row), CHAR(10)) + CHAR(10) + JOIN(COLLECT({Classification}, {Batch}, Batch@row), CHAR(10)) + CHAR(10) + JOIN(COLLECT({Status}, {Batch}, Batch@row), CHAR(10)) Resulting Field has:…
-
Can VLOOKUP work with Dates?
I have 2 data sheets, both entering the same data and same formula for the summary field: =VLOOKUP("GL Golive", [Task Name]:[Start Date], 11, 0) I am trying to get a matched start date for the row contains task name "GL Golive". However, one sheet works perfectly, the other sheet shows invalid operation. Both of the…
-
How do I insert or delete a row in between rows that have links and it not affect the links?
I am working with a "customer view" and a "master sheet". This sheet allows the customer to only see certain information and update it and the links add the information to the master sheet. We need to insert rows at times as well as delete rows, but currently when we do this the links stay with the cell/row, but the…
-
Nested IF formula breaking out too early
Hi! I have a series of columns describing deployment dates. Users can enter up to 8 deployment dates (1 per column) and an associated Type (of deployment) column: Production Event Date 1 = 2/15/22 Production Event Date 1 - ON / OFF / LIVE = OFF Production Event Date 2 = 2/20/22 Production Event Date 2 - ON / OFF / LIVE =…
