-
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!
-
Excluding two values for Sheet Summary Formula
Hi all, I was wondering whether you might be able to help. I have a column "Status" and I would like to write a formula for a sheet summary field that counts the number of status' that are anything other than "On Hold" and "Complete". I've tried various COUNTIFs but none seem to be working! Any help on this would be great!…
