-
Search and find the last sequential duplicate key in a Smartsheet?
I have a target sheet that has duplicate keys where the keys/rows can be found throughout the Smartsheet. I need to display the column named 2501_January value from the last sequential key's row in the target sheet. In this example, I want to search and find the last Row Key Rev-2 at the bottom of the Smartsheet from my…
-
Formula to search across multiple contact column
Hi, we are using the following formula, but it only works for calls with a single contact per cell, even though is looking into multiple contacts per cell. We managed to fix this by using a helper column that's the same as the contact column but set as text property. Is there a way to make the formula work with the…
-
Countifs for cells containing a letter
Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks. My formula is below and I want a solution for the…
-
Copying to Children Rows while Editing Parents - Best Practice Question
Hello! I have a large master sheet (900 rows) with ancestor levels of 0-4. Whatever is in ancestor level 1 in columns 1-12, I need that to copy down to ancestor 2 for all of the children of that parent. I need this to happen throughout the sheet. But I need the information to be fillable in ancestor 1 (not locked up with…
-
Rank Formula Multiple Results
I have previously received help with Ranking formula where there is more than 1 result it needs to rank the most recent week, which was resolved and worked fine - until last week. The new issue is that I have the rank 3 & 4 is being excluded When reviewing the data I think this is the issue, just not sure how to adjust the…
-
How do I only get the 25, 26, 27, etc out of 2025, 2026, 2027?
I need to pull out the last 3rd and 4th characters of a long year format CCYY where I only pull out the YY. So, in my example, I need to find the year 25 out of 2025. 26 out of the year 2026, 27 out of the year 2027 and so on. Basically ignore the first two characters of the long year 2025 so I will only be seeing the 25…
-
Pulling data from another sheet based on two criteria
Hello! I am having trouble getting this formula to work.. The goal is to pull the quantity of an item from a reference sheet to this sheet if the Spec #@row on this sheet matches an EAN on the reference sheet, and only if the Disposition value reads "Released". This is the formula I have cooked up, but get an…
-
Count for multiple values in a range
Hello, I'm having some difficulty setting up a countif formula for my sheet. I have a long list of barcodes as a range, and I'm trying to count how many times specific barcodes show up in the list. I currently have it set up to count for two barcodes each in separate columns. =IFERROR(IF(ISBLANK(Barcode@row ), "",…
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…
-
Create a sheet summary, which counts RAID items and their statuses from another sheet
Hi there, I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below Type (primary): Action Decision Dependency Issue Risk - with their statuses (columns): Not started In progress On hold Completed Cancelled This is…