-
Lastest Update
Hi I have sheet - Incidents Recorded for the Month, which record the incidents that occuring within a month. see the pic below…. I want a formula that can return the latest Incident Description when a new incident is added. I have used the following formula - =IFERROR(INDEX(COLLECT(CHILDREN([Incident Description]@row);…
-
Date Dif Formula
Hi Smartsheet community, Looking to see if anyone has figured out if it's possible to use the the DATEDIF formula. When a Start date and end date are used in the formula it would produce the years and months between the date range. Example Start date: 1/1/25 End date: 2/1/25 Tenure: 0 years, 1 months The formula that i use…
-
Date Formula with Cross Sheet References
I am trying to figure out a formula that will pull data from one sheet to another if it meets a set criteria and it happened during the previous week. I am using the formula below now: =COUNTIFS({cross sheet reference column}, "specified data", {Date}, >=DATE(2025, 2, 9), {Date}, <=DATE(2025, 2, 15)) and it works great!…
-
Join 2 Columns that are not next to Each other.
I am trying to Join 2 columns of text, but they are next consecutive columns. As this is different from Excel, I am having a hard time with it. I wish to join text from the # column with the Task Title column, and there will be a " - " to seperate the 2 fields. When finished, it should look like this below. And the formula…
-
Assigning numeric values to drop down menu options
I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell. Drop down menu options in each cell are: Needs Contributor Contributor Reviewing Ready for Production If 'Needs Contributor,' is chosen, then adjacent cell is populated '1' If…
-
How do I import an entire column from one sheet to another without getting #unparseable
I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this? This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)" We're gotten "=INDEX({A. Wash Schedule Range 1},…
-
Error when refrencing a date column in formula
I am attempting to change the Fabric status column based off the dates in Fabric A,B,and C received date columns. I want to return a value of Received in the helper column if there is a date in Fabric A received date, unless 2nd fabric required is checked, then Return the value of Received when there is a date in both A…
-
Count the number of instance of 50% and 60% for each unit. If the unit appeared twice..
I need help with the following. I want to count the number of instance of 50% and 60% for each unit. If the unit appeared twice, count only the most recent value based on the date. The formula will be on the sheet summary, and I entered the expected result.
-
Mapping Closed and Open items from another worksheet into another worksheet
I am trying to take open and closed items from one worksheet and plug in the totals based creation date and closed date into cells within another worksheet and separate them out based on airline and NDC or Graphical selected in the row Does anyone know how to do this? I'm struggling Data document: Amadeus: TC Known Issues…
-
Date Range Formula Assistance
Is there a formula that moves entries to the next month if it falls within a certain date range? For instance, entries from February 16th - March 15th would be placed in the April cohort. I would like this formula to be permanent each month.