-
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. https://community.smartsheet.com/discussion/105462/duplicate-rank-what-formula-would-return-the-most-recent-week The new issue is that I have…
-
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…
-
Need help with IF AND statement using symbols
I need help with using symbols with formulas. The column property is set to symbols. My current working formula is: =IF(TODAY() > [Remedy Deadline]@row, "Red", IF([Finding Status]@row = "Finding is Closed", "Green", "Yellow")) However, my first IF condition needs to satisfy two conditions: (1) (TODAY() > [Remedy…
-
Adding a "Select-Case" Style Function for Easier Multi-Condition Handling
Hi I’d like to request a new formula feature that allows users to evaluate multiple conditions more cleanly — similar to the Select-Case structure that I had found in a programming language. Currently, we rely on nested IF() functions to test multiple conditions. While this works, it becomes extremely difficult to manage…