-
Aggregate Summary Field Data from Multiple Sheets
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details Any suggestions to the best approach appreciated.
-
Counting overdue tasks from a lot of project sheets
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a report that shows only the tasks assigned to them from all the source sheets. Previously, we had a dashboard that showed each…
-
Report from multiple sheets - but automatically including new sheets
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each WorkSpace (so across sheets), but also have it add new sheets as new Workspaces are created. Is that…
-
Seven Most Current Entries for each Question for Each Location
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. This is the formula I started using based on responses in the community: =INDEX({TEST Range 2}, MATCH(MAX(COLLECT({TEST Range 4}, {TEST Range 2}, [Q1]@row)), "Clearfield", {TEST Range 5}, 0)) This formula…
-
Report? Summery Count of rows
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming in: Building | Unit Number | Rent Ready |.... I need a report to return Building | Number of available units (count number of…
-
Report on Tasks due including Header
Hi all, Can someone provide me a workaround here. I would like to run a report that lists all the tasks due to start in the next 5 days. But what I need is to include the Phase name, even though the Phase has already started. I have added screenshots of what I have done, but this adds all phases, even the ones that does…
-
Counting completion status off of a group of sheets
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am trying to figure out how to pull together a dynamic number for the total number of courses…
-
IF statement to update a column when box is checked!
Hi, I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED.
-
ABSOLUTE CELL LINKING
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the…
-
sort in report
i have a repotr based on sheet with ~1500 rows (parents and children). as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children. but, now i want to sort with another level: i want to show in report the parents row and…