-
How to count number of entries that fall between two dates
Hi! I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries with…
-
Formula for Multiple Checkboxes
I have a sheet with submission form, in the form there are two different sections. One where they have to pick a checkbox option from a list of 4 and the other is one out of 8. I set it up this way to be able to provide details for each selection. I'm trying to find a formula in the sheet so I can hide all the checkboxes…
-
Capacity vs Demand Utilisation RAG Column
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q1 Capacity > Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke
-
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…
