I had to break down two cross sheets due to the size of data. I created another sheet with a form. I would like to have an index match formula that if a name was found at the row, it would cross-refer…
Hello, let me start off by saying any assistance available is greatly appreciated!!!! In our work schedule we use parent child hierarchy. Through the use of other community discussions, I found a form…
I have a sheet where I automate importing new rows whenever there is a change in spend. I want it to replace the previous row(s) that was imported with the same placement name so only the most recent …
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank ret…
I have a master equipment sheet with different projects on it. I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when t…
Hi, I am trying to setup a formula that will return a product description if the entered value matches one of three values. The inventory system we have uses tolling numbers, as well as bulk and final…
I want to set up a formula that reflects Status in the Parent row. Below are the conditions: If all CHILDREN tasks are Not Started, then PARENT status is Not Started If any CHILDREN task is In Progres…
I manage a sheet where we track Inspection reports and compliance statistics for meeting 24 hour deadlines. I calculate regular submission turn-around time by date submitted - report day. Problem is, …
Need help with a formula that will hopefully eliminate the need for an additional "helper column". We have built an API that pulls various information regarding our 700+ Pharmacies from our data base …