-
Create a summary sheet
I want to create a sheet that computes all types of summary info from various other sheets. I have sheets called ProjectA, ProjectB, ProjectC. I also have a sheet called Summary-Info. In Summary-Info I want to create rows of metrics, such as Count of number of rows in ProjectA with Status="Done" Count of number of rows in…
-
Counting Columns
Is there a formula that allows me to count the number of columns in a sheet (to include in a sheet summary/)
-
Rolling 12 Months and Rolling 4 Quarters Formulas for Dashboard Charts
Hello, I have a metrics sheet that has static start and end dates for each month of 2023 and 2024. The requirements changed for the dashboard and management wants the dashboard charts to show data for a rolling 12 months and a rolling 4 quarters. This screenshot shows the column setup and formula I have for calculating the…
-
Dynamically referencing parent task row in COUNTIF/COUNT formula for child task completion ratio?
Hello Smartsheet Community, I'm trying to calculate the ratio of completed child tasks for a specific parent task in my sheet. Currently, I have a formula that works when I manually specify the parent task's row number: =COUNTIF(CHILDREN([Task Complete?]70), 1) / COUNT(CHILDREN([Task Complete?]70)) However, I want to make…
-
Searching more than one worksheet to return value
I am utilizing multiple worksheets (one for each year) but have one sheet that has some consolidated information, and I would like for it to be able to pull from the appropriate year sheet. =IFERROR(INDEX(COLLECT({Quote Log 2024 Quote Status}, {Quote Log 2024 Quote #}, @cell = [Quote Number]@row), 1), "") I would like for…
-
formulas
Im trying to calculate the remaining amount to be billed on a project based on the Job % of completion, factoring in the original contract amount, the deposit and remaining amount that is due
-
I need a formula to find the average of the Count of Training IDs
I have a grid that intakes via a form, training evaluation answers. Each row of responses has a TrianingID associated to a specific training. I have been ask to find the medium average if the number of responses received per trainingID It needs to be a column formula due the new TrianingIDs populating as more and more…
-
Generate child rows from form and link to a specific Parent
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just discovered, I don't like the way it works. Below is the template I pulled. The last 2 records are what I entered via the…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…