-
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.
-
Stacking Info from rows into Columns
So i use Smartsheet forms to Have my workers Log what they Completed on a Job Site as a Daily log. In a Day they Can do up to 8 tasks a single day and with the Form its set up to be just a 1 time Fill out to Track everything with out having to do the form 8 times in a row and just doing it once to cover everything. is…
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…