-
I am trying to count how many dates have a specific YEAR in a cell for a given row...
=COUNTIF([Date of first absence]:[Date of first absence], YEAR(@cell) = 2021) It keeps giving me #INVALID DATA TYPE
-
NEW! COUNTIF not blank....
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Formula - Adding a Column
Today, I created the following formula in a cell =IF(AND([Roommate in Room?]@row = "Yes", [Requested Bed Type]@row = "Double"), ".5", IF(AND([Roommate in Room?]@row = "No", [Requested Bed Type]@row = "Double"), 1, 0)) As you can see one of the variables returns a .5. The formula works great until I go to my sheet summary…
-
Sheet Summary - grabbing Text of the largest entry using COLLECT
Hello all, I need to be able to search through a list of IDs and grab text from other column(s) associated with the highest entry for the ID. My ID is made up of two numbers: the first represents the room, and the second is the next sequential number. An example would be 300.5, where it would be Room 300 and the 5th (&…
-
Formula for adding all figures associated to a specific date
Good Day, I would like to add up all the "Cost Price KES" amounts associated to a specific "Delivery Date". I am trying with the current formula =SUMIF([Cost Price KES]5:[Cost Price KES]652, [Delivery Date]5:[Delivery Date]652 = 4 / 1 / 22) which is not working. Can someone please assist me?? Thanks!
-
Can COUNTIFS count on a column with values returned from a fomula?
This seems so easy, so I'm sure I'm doing something really dumb that I just can't see, but I can't get this COUNTIFS formula to work. It keeps returning "#NO MATCH" when I know that there is a match. I'm trying to count the number of times "EOX" appears in the Company column and "Reviewed with CSR" appears in the…
-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
-
Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B",…
-
Unable to Perform a Global Update on a Sheet Summary Field
I am trying to replace a formula in a Sheet Summary Field and it doesn't do anything regardless of what I choose. After adding Advanced Criteria [ROW] Is Profile Data doesn't seem to do anything. It appears I am missing something or it is not working?
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
