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.

No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…
Automatically Copying Cell Data in a Row
How do I automatically copy "Bill to" Name, Address, City, State, & Zip information to corresponding "Jobsite" cells, when the information is the same, by simply checking a "Same As billing" Checkbox on a Form? I tried this by using a formula on the sheet, and it worked well on the sheet but, when new "Forms" were…
How to Use MAX Function to Find the Most Recent Date?
This discussion was created from comments split from: Comparing dates.
Counting Days in Calendar View or in Sheet Between Date Ranges
We are implementing a system where people will be submitting time off information across our company. We have multiple regional directors (30+), so I'm trying to figure out how best to show each of them how many people they can anticipate to be off each day of the year within their region based on the date ranges we're…
How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
Histogram on days past
I'm trying to use a sheet that i have created to capture issues; but I'd like to create a histogram of days past of when they've been discovered. 7 Days past 14 Days past 30 days past Etc.
Using COUNTM Function to count more than one zipcodes listed in one cell
Good Evening All, I am collecting zipcodes in one column, a person could list more than one zipcode in a cell. I would like to total the number of zipcodes as the survey responses come in real time. Its okay if I count duplicates as well. This is a survey so I am using the text/number format. Issue: COUNTM does not count…
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
Help with formula
Hello I am working on this new formula where are trying to calculate the verification due date. The original way we were getting the value was when the date format was in a MM/YYYY but now the dates will come in a MM/DD/YYYY format when having this format the output of the formula we created for the Verification Due Date…

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