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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

SUMIFS With Multiple Criteria
Good day Smartsheet team, I'm a hardcore Excel user attempting to migrate my skills over to Smartsheet and I'm getting lost in the translation. Attempting to set up a formula to pull specific data into a sheet using SUMIFS. Here's my formula: =SUMIFS({GLData Range 1}, {GLData Range 3}, MONTH(@cell ) = 4, {GLData Range 4},…
WBS Numbering Error
I'm not sure if anyone will be able to help with this one, but I am running into an occasional problem that I don't quite understand. Essentially, I have a WBS numbering system running to give tasks an ID, and then using the ID to look up a letter equivalent from another sheet, and using that for the Item Label of each…
Smartsheet Build Version
How can I find the product build version for Smartsheet and other products? Thank you, Ron
COUNTIF formula help
This discussion was created from comments split from: Using COUNTIF in Sheet Summary.
Count the # of times a person was assigned a specific request type task and in what month
Hello! I need help applying a formula to reflect the following. Background: We have two sheets: Observe Request - Completed Client Insights Client Insights Tracker What we need: Apply formula in the client insights tracker that pulls from the observe request - completed client insights file that shows the count (#) of…
Odd behavior with Index(Match
Using a basic Index(Match on 1 criteria to cross reference 2 sheets. I've checked multiple times that 1) the cells pulling in are actual numbers (no formulas), and 2) there is a MATCH to pull in. Here is the formula - appreciate help on what I'm missing =INDEX({Equipment Leadtime - MPTs MVA Limit}, MATCH([MPT…
Assistance Needed with Cross-Sheet Formula Set Up
I’m trying to use a cross-sheet formula to pull data from my Primary Sheet into my Secondary Sheet in Smartsheet. My goal is to display the "Idea #" and "School Name" from the Primary Sheet in my Secondary Sheet for every row where the "Yes/No" column in the Primary Sheet has a value of "Yes." Primary Sheet Details: Column…
Scoring Formulas?
I need help coming up with a formula that assigns a numeric value to a particular response in a cell of drop down options. Multiple options can be selected. For example, a cell drop down has four values to select from: 1A, 1B, 1C, 1D. Each selection is assigned a value of three points. So, if 1B and 1C are selected, the…
Download Column Names & Column Types
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
Projecting Project Burn Across Different Dates and Durations
I've looked at several examples but can't find something that helps me close enough with this item. I'm brining in budgets from another sheet, same with the Start, End and Duration for each task appropriately. I'd like to project the total burn for each month associated with the project, but only for the portion of the…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags