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.

=IF(AND([Yard Location]@row = "Galion", [Pole Size]@row = "35/4")), SUMIF({Pole Count Detail Range 1
Getting an "#UNPARSEABLE" error and cannot figure out what it is. I am trying to sum the pole count for size 35/4 in the Galion Location. First sheet where we want the formula: Sheet that we are pulling the data from Any help is gratefully appreciated. We are a bit new to the functionality of SmartSheet. Regards, Laura…
Is it possible to generate a part number from row data?
Can this be done; we currently manually generate part numbers and I'm wondering if it can be done using a formula or another option in Smartsheet. example below. Part number would end up being, SDE-04111YI2E82Y from the inserted URL Any help would be great.
Formula for IF THEN Date
Hi all, I am trying to write a formula for an IF THEN situation but I am stuck. I need to make a formula to show a value per month only within the start date and end date. For example, below is a picture of a row on the sheet I'm working on. I need to create a formula below each month that would show the monthly production…
Formula to return first names of a contact cell.
Hello, I have a contact list column that allows for multiple contacts, and I am trying to have another column give me only the first names in text. Is there a formula to help me do that? In a cell where I have 2 contacts, I have only been able to get it to give me 1 of the first names.
How to pull text after a multi-character "delimiter"?
Tried searching and couldn't find another discussion that matched my issue. I am attempting to write a formula to extract only what falls after the "DBA" portion of a company's name. For example if the company name is "Vance Refrigeration DBA Kool Guyz" then I just want to pull "Kool Guyz". I've tried using FIND and LEFT,…
Copy Rows automation to other sheets in a template
Hello, I have a template in Smartsheet with a copy rows automation that transfers rows into another sheet in the same template. When I create a new project with this template, the copy rows automation does not automatically point to the new sheet in the project. Instead, it points to the original template sheet, which is…
Did they change how contact list and formulas interact?
I have a sheet that is mapping the supervisor email from a different sheet using vlookup (I want to keep this formula active in case there are supervisor changes). The format for the supervisor email is contact list. I'm using the supervisor email mapped in a countifs formula that was working last week. Now I'm getting #NO…
Help with setting up automation
Hi! So In the Advanced Formula Handbook, it looks like there's a formula that if implemented correctly, we can match it with an automation to notify someone that once a dependent task is completed, you can notify the assigner of the next task that it's ready to start. Has anyone had any success with doing this? "Your sheet…
Dynamic Dashboards
Hello - I have a source data sheet with the below columns: leader category level access list Access list is used for row level security and ties directly to leader. From this sheet I have 3 aggregated reports: 1 for leader, 1 for category, and 1 for level. The reports are also filtered by access list has any of Current…
Countifs Formula - Month & Year
I have used AI and still getting an #INVALID DATA TYPE" error when I try to create this formula. I am trying to count if the "Renewal Month" column is January and the "Renewal Year" column is 2025. Below is the formula I am using. If it makes a difference, these two columns are populated by a formula to get the month and…

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