-
Index/Collect/Match help
Hi I have a sheet that has epics, stories, tasks and I want to extract only the epics to another sheet. layout is simple Name IssueType Epic 1 Epic Story 1 Story Story 2 Story Task 1 Task Task 2 Task Epic 2 Epic Story 3 Story Story 4 Story Task 3 Task Task 4 Task I want the other sheet to only have Epic 1 Epic 2 thanks so…
-
Unparseable and then need to scale up IF statement
I have the following - =IF(OR[Does pipe size match drainage drawing?]@row="",[Does pipe material match drainage drawing?]@row=""),"Awaiting assessment","Test") This is imparseable - is this the blank check bit - ""? I have noticed too that I would like to check for a 'No' in either of the cells. A 'No' would replace the…
-
Check Box Question
Can you make a requirement to fill out specific boxes before you are able to check the checkbox? So basically you can't check the box unless Column/Row A1 -- B19 -- and M24?
-
Populating a dropdown based of the entry in another dropdown
Apologies if this has been asked and I just cant find it. I'm new to Smartsheet after spending several years working with Access. I would like to have a dropdown auto-populate based off of the selection in another dropdown. Each selection in the department dropdown will have multiple "areas" within them. So if I selected…
-
Reports using HOURS past Creation Date/Time Criteria
Hello friends, I need to be able to create a REPORT where the only rows that appear are those that are equal to or greater than 3 hours past the Creation Date/Time. Is this possible?
-
COUNTIFS Formula not working when I add an ISBLANK statement
I have a COUNTIF formula that I can't get to work once I add an ISBLANK statement. This is the fomula that works: =COUNTIFS({Payment Type}, =$Status@row, {Case Date}, MONTH(@cell) = 8, {Case Date}, YEAR(@cell) = 2020, {Status}, ="Completed") When I try to account for rows where the Payment Type is blank, I tried this…
-
COUNTIFS Formula For Total Number Of Requests Per Month Assigned To Contacts
Hello, I am trying to troubleshoot a formula to achieve the following outcome. Outcome: Count the TOTAL number of rows in which the [Request Date] column is March (3) AND the [Requestor] column is any of the following contacts: Jesper Poulsen Libby Martinotti Michelle Wisbey Annel Ayala Anita Miazga Amanda Ayre Alex…
-
Autofill Cell When Another Cell Has Info Typed
Hi all, I have a worksheet where I am trying to find some solution/action for the below. I have a project registry sheet that I am trying to find a solution to autofill certains cells. There is a column for Customer Name, Customer Email, Customer Contact Number. If I type in the Customers Name, how can the corresponding…
-
Question on assigning a qualitative value based on quantitative info from members of the same group
Hi, I am looking for help on crafting a formula that would allow me to discriminate between [Type] -> "Dna/Seq". Right now, I know that they are either DNA plate barcodes, or Sequencing plate barcodes based on the "pcr" prefix. However, I would like to be exact with these and say it is either DNA, or Seq. It is fairly…
-
COUNTIF and VLOOKUP?
Good afternoon everyone, I hit a bit of a snag and I am curious to know if I may get some help. I have a tracker that we are using Smartsheet for and based on the type of item that is added in, only certain check boxes are required to complete the work. Originally I had done a massive COUNTIF formula where I had typed up…
