-
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…
-
Formula to exclude blank cells
I have a formula set up to return a "yes" for all duplicate phone numbers and a "no" if not a duplicate, however, its pulling all blank rows as well and making my sheet look messy. I need to exclude blank cells. My formula is: =IF(COUNTIF(Phone:Phone, =Phone@row) > 1, "yes", "no") thanks.
-
Extract Predecessor Row Numbers
Hello, I'm trying to design a set of formulas to extract the individual predecessor row numbers from the Predecessor column. The idea is the first predecessor row number would appear in the P1 Row column, the second predecessor row number would appear in the P2 Row column, and so on and so forth (up to five predecessors).…
-
Include Images On A Form
Hello Smartsheets Community: I am trying to put together a simple order form for customers and I would like to include the images of the items that are available for customers to order. This way they know exactly what they are ordering. Does anyone know if this feature is available on forms? Best, Anthony D'Ambrosio
