-
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…
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
Same Formula returning a blank cell
Hi, I am working on updating an error message to return "No Resource Assigned" however the same formula is now returning a blank cell. Both columns have the same properties (contact list), and this same IFERROR(VLOOKUP) formula has worked on multiple rows prior to this blank cell and continues for the rest of the columns I…
-
Dashboard Reference Data
Hi, I am trying to create a Dashboard reference sheet. I want to display to the client the number of quotes they requested and the number of quotes we presented to them on time. Quotes have a time line based on $ value. I don't think I have the right formula to capture the data accurately. What I need is if the quote due…
-
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…
-
Formula Syntax Help - Identifying suffix on number.
I have a sheet tracking orders. Each order has multiple order lines (each item on an order has a separate line with a decimal suffix). I would like to identify each primary order line (order line ending with ".0" but I'm struggling with the formula. I currently have this keyed as a formula =if(Order…
-
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…
-
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…
-
Running INDEX / MATCH formula only when certain criteria are met
Hi there, This title might be misleading, but couldn't find a better way to summarize. Apologies! I'm trying to use an INDEX / MATCH formula to pull in data from a secondary sheet when the search value in my main sheet matches a cell in the secondary one, but if no match is found, leave the existing cell text as is. I…
-
Check a Box based on a checked box in another column
This is a formula I wouldn't typically struggle with but I am having experiencing formula block right now... I am creating a sheet where new lines of data are entered for a test that is run. The unique identifier is the "batch number" and multiple lines of data may have the same "batch number" as tests are run until the…