-
How to find average for two different items?
Hi all, I'm trying to find the average day to process two different types of material. 1. raw material, 2. non-testing material (Material Type Column). In the release timeframe column, I have counted the days between the created and release date. But what I'm trying to do is to get an average time to release raw material…
-
Lookup with Duplicate Values
I am trying to cross reference another sheet and return all the values within a column that are state one. In this example, I am trying to get the Jessica Jones, Boba Fett, Mickey Mouse, Bob Saget, Betty White and Meatloaf values returned onto a separate sheet (in separate rows- I do not want these values condensed into…
-
Index Match - Match returing worng row - sometimes
Hi Smartsheet Gurus I have a sheet that has a listing of few hundred projects and a column for each month with the number of hours being charged for each project for that month - some have values, some have a value of zero and there are no blanks. I am doing an =Index(Match - formula looks like - =INDEX([Project…
-
Pulling data into a "master sheet"
Hello all, I am trying to pull select data from multiple sheets into one "master sheet", however I am struggling to find a working method. I am unable to use reports due to them not connecting with datashuttle. I have tried VLOOKUP, Copy Row automation, INDEX/MATCH and a few more but i can't get them to pull all of the…
-
=NETDAYS
I keep getting an error message: I am trying to set the duration between when approval to close and approval to open but in hours and minutes. When I referenced the Sheet to {Approver Time Stamp Open} I only chose the one column. =NETDAYS([Approver Time Stamp Close]@row, {Approver Time Stamp Open}@row)
-
Vlookup / @row usage
In the Vlookup formula, Category@row references 4 contiguous columns to obtain one value, I added a 5th column and Category@row does not recognize the 5th column. How do I redefine Category@row to use the 5th column ? VLOOKUP(Category@row, {GL Account X Ref Range 4}, 2, false) Thanks for your help! Amy
-
Pulling information out by business in to a new sheet
Hello, I have a large sheet where I'm tracking 7 businesses with a number of columns and metrics in each. Each of those businesses has a leader and I'd like to be able to create a sheet that would pull from the master all the information about their specific business. I can't seem to sort it out and any help would be…
-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3weeks from the due date will show in that column and so on I appreciate your help Rob
-
I am attempting to populate a cell based on information mastered in another table.
Sheet 1 contains a list of 83 values in a column (Alignment Look up L3) that each correspond to a value in the previous column (Alignment Look up L2). In Sheet 2, I have to select from the list of 83 values [Business Process (L3)]@row, thus want the previous column to autopopulate so I do not need to look it up each time.…
-
Count The Number of Upcoming Deliveries Within a Certain Number Days
Hey there! I've tried everything. All I am trying to do is produce a formula that counts the number of deliveries we have in a certain number of days that is not in "lost or cancelled" status. This helps us keep our eye on the prize to ensure we are doing all of our tasks prior to the delivery date so the customer can have…