-
Combining Join Collect & Children Functions
I'm trying to join all the values in children rows only if another column criteria is met. Here's what I have so far and thought should be working.. =JOIN(COLLECT(CHILDREN(), [Top 10 Keyword]:[Top 10 Keyword], "1"), ", ") Also, what's kind of strange is the formula works perfectly when I change it to…
-
AVERAGEIFS similar function
I need a formula (similar to an AVERAGEIFS statement in excel) to give me the average of the numbers in the right column if the value in the left column is prior to today's date. Thanks!
-
Counting filtered data
Hi - I have a question. I want to count the number of rows NOT BLANK after I filter the rows. Currently, the counting formula counts all of the rows even the ones that are filtered out. This seems rather simple but I could not seem to figure it out. Thanks in advance for your help! David
-
Percentage Formula
Has anyone built/used a formula to capture the percentage of specific responses in a series of questions? We're experimenting with Smartsheet Forms to be able to administer an exam. Each column would be a single-select dropdown of the multiple-choice exam question format. On the backend, we want there to be a formula…
-
Percent complete of a checkbox row
I want to take the Child rows and put a percent complete in the row I'm calling Grandparent I want it to be based off the child rows because the amount of Child rows in each parent group differ. So I want the percent complete to be waited off the over all check boxes of the Child rows
-
Averaging Invoice Totals
I am trying to AVG invoice totals by "Invoice Description" and "Packaging Description". So, I am trying to determine the average Invoice Total for "Plates" and "Body", "Plates" and "Lid", etc. Here's an example of my columns I am using to determine the averages: My formula is as follows but is not calculating properly:…
-
Sheet summary formula help
Hello, I'm hoping to get help on how to create a formula in my sheet summary. I have a sheet with a column of drop down selection for countries, and I have a column checked if unique tool. I am wanting to create summary fields for each country to know how many unique tools each country has. I have already created a summary…
-
Sumifs to roll up project hours?
I'm trying to sum up the total hours for a project based on a given date. However, the hours and project names are spread across 5 different columns for hours, and 5 different columns for project names. My Sumif comes up as Incorrect Argument. Do I need a combination of Countif and Sumif? Example, I need to calculate the…
-
COUNTIFS Formula, Multiple Criteria
Hello! We are trying to calculate how many days delay our projects are incurring. However we only want to count Special Conditions that have a "*" in front of it. So Special Conditions with * in front of it, summing up # of days delay in the next column. Totaling for entire column. We worked through some of the formula…
-
Using Collect with count if and count if NOT
I have the following formula I'm trying to run =COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT "Published")) Count cells with a target live date, where the checkbox is ticked, the type is native, and the status is NOT published. All seems to be working well until the NOT part. Any clue…
