Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
INDEX/COLLECT Formula for gathering list of data
Hi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions. On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that sheet is Column 2: Division (For example Tampa Bay Restaurant is in the Southern…
Count the number of "No" in the entire row across multiple columns
Hi, I have 45 questions in a survey in Smartsheet. So, that is 45 columns of questions. All the questions are single select "Yes/No/NA". One row of data equals one survey. Is there a way to count the number of "No"s in one row and put it in the "Failures" column? I am trying to get a count of the items that failed for that…
Trend Formula with R,Y,G balls
Good Morning Smartsheet friends, I am new to Smartsheet and have been working to learn as much as I can about this program. I'm trying to show my leadership the value in its usage. I'm trying to figure out a formula that will COUNT the number of weeks a R,Y,G ball is a specific color to show a trend. We track items by the…
Copy Row Automation
I am trying to copy rows over to another sheet once a date is reached and the respective review period has begun. The automation workflow I have is this: Trigger - When a date is reached Everyday at 6:00 am Condition - Where deadline is today Copy Rows I am not having any luck with the rows copying over to the other sheet…
Need a formula to count a multi-select dropdown cell if its contents include "has any of"
Hi there. New to Smartsheet so forgive me if this is basic. I have searched the forum but can't find the specific usage scenario. I am trying to create a Sheet Summary formula to count all the cells in a certain row [Tags] that contain a specific "tag" eg. "Mid-M". Seems easy enough but because its a multi-select dropdown…
Formula to count the how many times "Monday" is listed
This is for a ticketing system. I want to count the number of requests that come in on each day of the week. I am looking for a rolling YTD number. I have a metrics sheet that pulls the data from a closed tickets sheet. This is the formula I tried using: =COUNTIFS({Resolved Date Range}, CONTAINS("Monday", @cell)) Any help…
Calculating due dates
Hi there I am trying to calculate a due date from a "created date" column and a number column,. So want it to calculate the due date given the number in the "target turnaround days column" eg 3, but exclude working days. Can anyone help please, Melissa
How to pull in MAX Date based for "Charter Approved" and "Project Baselined" when they are 100%?
Hey folks, I'm looking to pull in the MAX Date for when: • Charter Approved is Dated and 100% Complete • Project Baselined is Dated and 100% Complete For the screenshot below, the date pulled in should be 10/05/2021 I'm not sure if it matters but the formula is going into a Text cell. Thank you!
Using Countif with IF statement
In my sheet I have a range I am counting which works fine. For example: =countifs([range name},System@row) Now I want to reference another range name the location which meets the entry in the row I can't see to get the order of syntax correct.
Is the only way to create a dynamic view from multiple sheets to use a report?
I am looking to create a dynamic view configuration that pulls the information from multiple sheets. I know that you can create a dynamic view of a report, so is this the only way to create a dynamic view of multiple sheets?
Help Article Resources
Trending in Formulas and Functions
Need to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…