Formulas and Functions
Archives for September 2020
Discussion List
- 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 …
- 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!
- 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 rat…
- 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 …
- 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 …
- 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 …
- 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 wantin…
- 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 name…
- 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…
- 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…
Help Article Resources
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hey friends, I'm finally figuring out a complex system to have a first sheet with a Dropdown data row, matched to a column with a helper row that only highlights the MAX (most recent) dropdown. I'm do…
- Expected CPM is generated using three columns from another sheet. Column 1: OSM SKU Column 2: OSM TF Column 3: OSM CPM I have tried IF/ IF AND / INDEX(Collect), all I get are errors. IF OSM SKU is xxx…
- Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…