-
Summarize Report Function with Dropdown Menu Selections
Hello, I am looking to determine the instances of a particular dropdown value entered into my sheet by using the report function with the summarize feature in order to determine, based on the weighted value, how large a portion of total any one category may hold. Easily thought about as a pie chart. My dropdown values…
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
-
Summary by Client
I created a ticketing process and the result is a list of tickets in a sheet. I want to be able to report on tickets by client. I am trying to avoid maintaining a list of clients for the report. In excel I would use a pivot table, I am trying to avoid needing that addon. Is there a way to take a list of data and summarize…
-
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…