-
Creating a list of text entries without duplicates
Hello! We have a large "master tracker" sheet where we house all the informationย about each of our units, one piece of which is a "neighborhood" designation, which basically tells us where on each of our properties the unit is located. Typically, there are somewhereย between 6 and 20 units in each neighborhood, and everyโฆ
-
Tracking Previous Week Order Completions vs This Week
Hello, This feels like a simple question, but the answer is eluding me. We have dates getting automatically logged for when orders come in/are delivered, and then another automation to log the date when the inspection is completed. I need to have two different results. One for when an order delivered from the previous weekโฆ
-
How to build an IF formula based on a date field
Hello, I am looking for help in building an IF formula that will return a number value, based on how far in the past a date is (using a date field). Where a date field is populated and depending on the date, a number will be chosen : 1 = a date that falls in the last 2 months from today 2 = a date that falls between 2 andโฆ
-
INDEX Match or INDEX Collect - formula error
Sheet 1: contains a list with Job #'s and info Sheet 2: Contains data, with job #'s I want to look up the matching "Job #" (Sheet 1) on Sheet 2 and then, if not on "Hold" (separate column), I want to pull in the cell data from a specific column named "Prep". This is the basic formula that I am using and I am getting errorโฆ
-
Conditional Formatting Help
Hello, Can conditional formatting achieve what I'd like to do, and if so, how? I'm coming up short and would love help. I have a daily task list for projects I'm working on. I would like to have the row turn red if the due date is 3 days away and the status column shows anything other than Complete. Is this possible? Thankโฆ
-
Vlookup or Index Match?
Hi! I have 2 sheets: Master Sheet Test Results Sheet Whenever a teacher inputs a mock test score in the "Test Results Sheet", I want that score to be copied to the "Master Sheet" in the same student's row. I could do this with this formula: =IFERROR(VLOOKUP([Student]@row, {Test Results Sheet}, 2, 0), " ") Now, I'd like toโฆ
-
How to ignore past entries from the same user?
Here is the issue. I am creating a self assessment form. A user would enter their name, ID#, and assess themselves against a competency. In the image below, you see the user has a gap to Access Tech Documents. They then closed the gap to this competency and updated the form to show no gap. My metric is gap percentage, andโฆ
-
Complicated COUNTIF Formula
I finally got my formula right to count based on certain criteria but now I'm trying to figure out how to get it to enter a blank instead of a zero: =IF(COUNTIF({Status Range 6}, [Column 6]@row = 0), "", COUNTIFS({Status Range 6}, [Column 6]@row, {Status Range 3}, @cell <> "New Configuration")) What I'm trying to doโฆ
-
Find and Replace across multiple Rows and Columns
I have created a calculation sheet that references a number of other sheets for Q3 2022 and is using a formula as follows: =COUNTIFS({All Countries SSOT Reference Sheet for Das Range 1}, Country3, {Countries SSOT Ref Sheet for Dashboards A- Range 1}, "ALXN 1840", {Countries SSOT Ref Sheet for Dashboards A- Range 2}, ="Toโฆ
-
Searching for specific information
Is there an easier way to search for information when you don't remember where it is located? (HA!) For instance, I'm looking for specific individual but can't for the life of me remember which one of the many sheets and workspaces they could possibly be in. Does the search engine recognize wildcards ("name", na?me, na*meโฆ