-
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…
-
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…
-
Index,match,match
I'm having the hardest trouble figuring this part out. Even after doing some searching and people asking for the same thing. When i try to use it on my sheet it doesn't work. I want to do excel's version of index,match,match. I've tried index(collect), join(collect), max(collect), but i am doing something wrong apparently.…
-
Counting Multiple Columns with different criteria
Hello! We manage properties with under different statuses (Available, Expired, Under Contract, etc.) and use another Column called "Dead" to filter our reports. We created a checks and balance sheet to view the counts at a glance for high level overview, and we are unsure how to use the =COUNT and =COUNTIFs on two columns.…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
Formula Question
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
SUMIFS function
Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, where the following criterias are met: It must say "Ida Skou Andersen" in the column…