-
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…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Trying to get a list of distinct values across multiple columns based on multiple criteria
Hi, I am trying to list all the distinct values for the Year 1 through Year 4 columns but only for the rows the WBS row value is equal to WBS Target value and skip any blank cells. I have a helper column to index up to 10 distinct values (Screen shot below) Any help is greatly appreciated!
-
Dynamic Date Calculations
We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many days it takes to complete the task. I want to make a date column to say "this is when this task is due" but I'm not sure if…