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.

Summary Sheet. I want to reference other calculations in Sum Sheet but cannot use values
I want to calculate the quarter of the year it is today()... Below I calculated Month1(Today()). Below comes after and I want to determine the Quarter. Can I use the Month1 value calculated previously? Right now the equation below is "Unparsable". Thank you. C =IF(Month1<4, 1, IF(AND(MONTH1 < 7, MONTH1 > 3), 2,…
If Formula with Dropdown conditions based on Dates
I'm looking for a formula that could be integrated into a drop down field based on a past date. I'm trying to have the "Status" column automatically flip to Off-Track if the date in the "Finish" column is now in the past and the "Status" column is not already in At Risk or Completed status. I'm able to use =IF(Finish1 <…
Range of a number between three options - is this possible.
Hi All, I need to track project by number of working days within 30, 60, or 90. I am trying to write a formula to look at (1) number and determine if this is within 30 days, between 31-60 days or anything 61+. I am hitting a wall on trying to determine the best route to calculate this information. Any thoughts and or…
Adding Numbers for Each Resource Formula
Good Day Smartsheet Community: I am trying to reference Each Resource and the total number of Points they have in Each Sprint. For Example: Ron has several tickets with various Points. I would like to add those in a another sheet for him using a formula with the following criteria: Countif Name is Ron Sprint is 5 Collect…
Sum + Collect Formula - without knowing what the collect "criteria" might change to.
Hi, I'm trying to collect the sum of income received from different sources. However, I don't know what the sources may be as new ones are added. Is there a formula/Solution that can look for all the different income sources and then sum the income amount: ex: SSA - $1,100 Pension A - $800 Pension A - $100 SSA - $1,000 I…
how do i create a column to get the average of other columns with star ratings
looking for the average star rating with respect to the other five columns that solicit a star rating.
Nested formulas
Hi, I have 3 formulas and I was wandering if I can combine them into 1: =COUNTIF({Survey Date}, Label@row) =COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8") =Percentage@row / Count@row Thanks much!
Formula to join text strings from 10 columns
I tried Join Function to add text strings from 10 different column using following but no success: =JOIN([Region 1]:[Region 1], [Region 2]:[Region 2],[Region 3]:[Region 3],””) Can anyone help please? Thanks Prajna
Referencing data in another sheet when other sheet is continually expanding in an IF(AND situation
Sorry if my question is too simple but this is an important bit of coding. I am referencing a continually expanding sheet what would be the coding like: Quarter1 is calculated in the Summary Sheet of the current sheet. Current Quarter1 is 04-2020. I want to check if a value in a pad in a sheet (Well Pad List) matches a pad…
Smart Sheets Form to check if a cell is blank or has a value.
I'm using a Form to enter a daily count by selecting a date and entering a donation value for that day. The form(s) default to one of four locations. When the date is entered for a default location I want to check to see if the cell to be populated is empty or has a value. This would eliminate duplicates. I have a columns…

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