Sheet Summary
Discussion List
- Below is an example of one of my sheets in smart sheet I would like to add a sheet summary that : Shows the status of the overall project automatically ( in Green/Yello or Red) by calculation, as in l…
- I have the following items I need help with: 1) I would like my children rows to automatically display Parent | Task Name For example in this configuration: Parent 1 Child 1 Child 2 I want to see belo…
- Hello, I'm trying to filter a summary sheet metric using the following formula but I keep getting "NOMATCH" or "UNPARSEABLE" depending on what I move around. The issue seems to be when I add the Count…
- 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…
- 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 dro…
- 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…
- 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 ex…
- =COUNTIF([Date of first absence]:[Date of first absence], YEAR(@cell) = 2021) It keeps giving me #INVALID DATA TYPE
- 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]…
- 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 = …
