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.

Cross sheet refrence formulas on a metric sheet keep showing errors until the sheet is opened
I have 5 large sheets (10,000 rows, 45 columns) mostly populated by DataTable that I'm collecting metrics from on separate metric sheets (1 DT sheet → 1 metric sheet). The metric sheets collect the metrics via cross-sheet references. Some of the formulas "break" (breaking the dashboard visuals) but quickly fix themselves…
Pull info from another sheet based on 2 criteria
I'm trying to pull in hours to what I'll call Sheet 1 from Sheet 2. I have flexibility in the way I set up Sheet 2, but I need Sheet 2 to be able to have various employees use the same project number. This would be one option for Sheet 2: In sheet 1, I will have the project number listed in a column, but will only have the…
Find cells matching a criteria and return combined results
Hi, New to Smartsheet and hitting a roadblock in one of my formulas. I have two sheets: Projects and Resources. On the Projects sheet I collect resource groups that will work on a project. Each project in a row might have either single or multiple resource groups. On the Resources sheet I have resource group names…
DateOnly YearDay off a day Time Zone Question
Hello. I have a question about the DateOnly and YearDay functions. Please see below (Pic 1). All dates after 7pm gets moved to the next day for the DateOnly and YearDay functions. I am assuming, not 100%, this is a Time Zone issue as I live in UTC -5 hours.(Pic 2). I saw a post (Pic3) that said that Smartsheet captures…
Combine results of multiple COLLECTs? Or alternate strategy?
I am trying to get a count of trainees in my app, each trainee has a unique "Member ID". A trainee is defined as meeting one or more of the following criteria: has a value of "Submitted" or "Issued" in the "Status" column of the "Reimbursements - Approved" sheet has the current grant year (e.g., "GYr 4") in the "Mentee"…
Help with SUMIFS in a sheet Summary Field
Hello! I am stuck - trying to leverage a sheet summary field to sum a total, where one of the columns has two conditions that I want to exclude from the Sum. I can get one of them to work: =SUMIFS([Amount]:[Amount], [Business Unit]:[Business Unit], "Sales", [Priority]:[Priority], <>"Required") It's that last condition. I…
Returning Multiple Rows Matching the Same Value and Skipping Rows that Don't
Below is what I'm trying to do and I hope someone can help me figure out the best way to do this. Here is my source sheet, Proposals: I would like a formula to look for any "Won" values from the Status column in the source sheet and return them into the Project Name column of my destination sheet (below). I would like the…
Moved: Workspace Panel - Default to Folder rather than Workspace
This discussion has been moved.
Capture column data
I am working on a construction plan set revision tracker where we are trying to capture dates for different revisions. There are 5 different revision types, and I have created a helper column to join the three items I want to capture. The problem is once I change the Revision drop down type, my information gets wiped out…
If Contains Contact Cell
I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this: If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even…

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