-
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…
-
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…
-
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…
-
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).…
-
How to check if Flag has been flagged in another sheet? Formula?
I have a metadata sheet that has At Risk row with a flag symbol, and I would like to check the other project sheet with an At risk column to see if any flag has been marked in that column. If any task has been marked in the project sheet, I would like the flag symbol in Metadata to turn red as well.
-
Where am I going wrong in this SUMIF formula?
Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner}) I'm trying to say, if the "Owner" on another sheet equals the Wholesaler on the row on my sheet, then sum the CP on that other sheet. The formula isn't throwing any errors, but is return an…
-
COUNTIFS giving INVALID DATA TYPE
Hello, I am working on a Dashboard for a Program Plan and I am trying to get a read for the amount of items in a particular sheet that are past due that are not completed. These columns are identified by "Target End Date" and "Health". Target End Date is a date column. Health is a single select drop down with the options,…
-
COUNT(50) on an Empty Sheet
Not so much a problem as just a question on a weird occurrence. I have two sheets, one with a checkbox column formula [sheet1] and one with a summary row [sheet2]. I have a very simple reference on sheet2 that is =COUNT({sheet1 Range 1}), where {sheet1 Range 1} is checkbox:checkbox. For some reason, COUNT({sheet1 Range 1})…
-
Calculating 14 day due date
Hello, I'm attempting to collect training metrics by department and I'm unsure how to incorporate a formula to identify criteria for training due 14 days from today. The below formula references a report with a Due Date column, not sure sure how to create the criteria for due dates 14 days from today. Thank you in advance!