-
Formula to Create a List of Non-Filled Cells in a Row (ignoring the first column)?
Hi, I have a sheet that lists a bunch of documents in the primary column. The additional columns list out the names of people who either get access to those documents, or don't. The corresponding cells are filled in with green or left blank depending on their access. I am trying to create a formula that will spit out a…
-
INDEX MATCH Formula
Hi, I used this formula in one column on Sheet 1, it looks at Sheet 2 and finds the Site Name and if the Status is Committed, it pulls in the number of Committed Trees. It works just fine for the Committed Trees column. =IF(INDEX({Inventory Agreements - Status}, MATCH([Site Name]@row, {Inventory - Site Name}, 0)) =…
-
Why is DATEONLY() returning the wrong date?
Hello All, Does anyone understand the behavior of the highlighted cell below? I believe it should be displaying "08/18/20".
-
JOIN only if cell is not blank
Hi there, Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank? The contents of the other sheet is generated from a form (and being constantly updated), so referencing the entire column is the only option unfortunately. It seems like it should…
-
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},…
