-
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…
-
Calculation for Variance in Percentage between Target column and YTD Column
Hello Community; I'm building a dashboard to reflect how different projects/programs are tracking towards targets. I want to showcase the following: 1) Projects that have gone above their targets, 2) Projects that didn't meet the target, 3) Projects On track to meeting the targets. I've already tried this formula…
-
Logging modified date/time of data in a column
Hi you all. I'm currently in the process of analazing some trends in a particular operation and one of the most valuable sources of data would be the ability to extract the modifications log for every cell on a particular column in a spreadsheet. So far I've looked for such functionality over the site but can't seem to…
-
Can we assign clients and link their info line to staff's individual work sheets?
We have a master list that talent inquiry forms populate and notify a manager. Once the manager assigns that client inquiry to a staff member, we would like to have it copied to their personal work pages. These pages then need to stay linked to the main page in order to keep updated notes, attachments, and status accurate.
