-
MAX Date help
I am trying to get a MAX Date: =MAX({1.1 Invoices Date}, {PK#2}, [PK #]@row) Is COLLECT required to make this work? I also tried this: =MAX(COLLECT({1.1 Invoices Date}, {PK#2, [PK #]@row})) No luck.
-
Build Hours/Cost Estimate Tool: Reference Entered Text Value from the same Colum in a Column Formula
I want to make a cost/hours estimating sheet that will sum the hours or cost of the children rows, but I want the cells with a hierarchy level of 1 to allow users to enter their estimated hours. Can I use an SUMIF statement in the column formula but have a mechanism that allows values to be entered in cells with the…
-
Use COUNTIFS formula to count certain conditions by date column
I want to use COUNTIFS formula to count the number of program participants who have received treatment and did not have a confirmed home plan by their specific release date. This is the formula I have so far: =COUNTIFS({Assessment and Intake Tracking_MAT Prison Range 11}, "Yes", COUNTIFS({Assessment and Intake Tracking_MAT…
-
SumIfs - referencing to same Cell
Hi Team, I have to calculate a number based on 3 criteria, i tried this formula but it says Invalid: =SUMIFS([Duration Completed]:[Duration Completed], Meeting:Meeting, Meeting@row, [Start Date]:[Start Date], [Start Date]@row), [Assigned To]:[Assigned To], [Assigned To]@row)) I tried Has and Contains but still showing…
-
Join two fields, one with text format and the other with a date (which is a result of formula)
Hi, Help please. I have a name in one cell [Service User] and a date in another [Visit Date] and wish to join them together to use as a lookup primary key value. The date is extracted from a date/time using a formula which is working fine. However, using the + or join formula does not bring the date half of the…
-
help
create an average of how many "Yes" there are when the columns where yes are are every other column and not all next to eachother. (there are 12 months of yes)
-
Is there a function that counts a cell if it contains a value rather than equals that value?
Is there a function that counts a cell if it contains a value rather than equals that value if you have cells with "dog", "cat", "cat dog" and you want to count "dog" using excel you can use this formula =COUNTIF(A1:A3,"*dog*") but the * doesn't seem to work in smartsheet
-
Index Collect Formula
Hoping for some insight on the Index Collect Formula. I have 2 sheets I am working with. Monthly Operational Metrics - this houses the monthly production goal by month in columns Daily Revenue Tracker - this has day-by-day detail, however I want to pull the monthly goal into a row to produce the daily production goal.…
-
How to combine IF/AND with INDEX & Match???
I'm looking to combine IF AND with index and match. I've gotten this far and I'm stuck. I'm trying to INDEX and MATCH data from 2 reference sheets and combine it with IF AND. =IF(AND(INDEX({3.0 IRS - Panera Column}, MATCH([23 Itinerary]@row, {3.0 IRS - Itinerary Range}, 0)) = 1, (INDEX({MLRS - Pre-Departure Email Col},…
-
How do I get a range of values from another sheet to feed NETWORKDAYS w/ holidays formula?
Hi, I'm super stumped on this one and can't find a solution. I have 2 sheets: The destination sheet is where I'm building the NETWORKDAYS w/ holidays formula The source sheet is called "Shutdown Days" and has 2 columns - "Client" and "Date". See screenshot below. I need to just pull the range of dates into the NETWORKDAYS…
