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.

How do I count non-blanks in a column?
Hi - I have a column in a referenced sheet that I need to count cells that have data in them. I'm struggling with the countif formula, not sure what to put for not counting the blanks and only counting the cells with data. Right now I have =countif({Lisa - test smartsheet Range 1}), …..and then I get stumped. The data is…
Date & Time
Hello- How do I add the date and time from start of task to end of task from this form? I need to measure the date and time from start to finish. I'm using the FORM. Thanks.
Search for Duplicate Names within Two Separate Sheets
Good Morning, I am trying to enter a formula that will give a show me when a duplicate name is enter into one or the other sheet I am working on. We will be entering names daily into each sheet and we need to quick way to find if we have entered the same name in twice. Please let me know what formula you think will be…
Need IF statement to return a value based on sum between two numbers
This is my "if" statement - where am I going wrong? I am trying to code each line based on a value to help drive other actions =IF([Total Sum]@row >= $50,000.00, VP, IF(AND([Total Sum]@row <= $2,000.00, [Total Sum]@row > $500.00), A, IF(AND([Total Sum]@row <= $5,000.00, [Total Sum]@row > $2,000.01), SA, IF(AND([Total…
If(and( question
hi, i'm trying to get a formula to work but there's a few different factors that determine which value should be returned. 4- development tiers 5- stage gates an auto date based on when stage gate changes right now i have this that is returning back "unparseable" =IF(AND([Development Tier]@row = "Version Change/Iterative…
calculate networkday and exclude holiday
Hi all, I am trying to use formula to calculate the manufacturing dates between 2 dates for a factory that located a country and exclude holidays only when this country has these holidays, holiday list is in another sheet. How can I use networkday and IF formulas to achieve it? Thank you!
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
Health formula not working
I'm attempting to build a formula to change the health color based on a drop down of 3 options. My logic is this: If Flu level is less than 5%, turn flu risk level green. If Flu level is between 6% and 9%, turn flu risk level yellow. If Flu level is greater than 10%, turn flu risk level red The formula I came up with is…
Formula to return a value from a row range
I need help to define a formula that returns the value at a column x row intersect I modified a formula found in the community that returns the column header in row 1 but have not been able to determine how to convert that into a column reference to be used with @cell or @row to return the appropriate value. The formula is…
Need help with a Stacked If/Then Formular
I'm trying to determine if an applicant has qualifying income for the # in the Household. I have an income matrix by max and min qualifying income; by # of people in household. I'd like to create a formula that looks at the 'total # of people in Household' column and depending on the result, apply the correct max and min…

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

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-…
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…
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…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags