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.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

SumIF Formula
I am trying to do a sum of cures by year, I have a column for the month "Date" and many other columns. here is the formula I am using but the result = 0 =SUMIF(Date:Date, IFERROR(YEAR(@cell), 0) = YEAR(TODAY(2020)), [Cure Amount]:[Cure Amount]). Thanks for your help.
Why do my Cells revert to previous value after formula saved properly?
I click save and then it does this: If I double click in the cell to see the formula it adds a ' at the beginning
Show multiple contacts listed in Assigned To field in a report?
Hi, I have a project sheet with multiple contacts listed in the Assigned To field, and I want to include all of them in a "Project Team Tasks by Status" report that shows the sum of all statuses by team member. I found that the tasks with multiple contacts assigned is not being accounted for in this report; only the task…
Help with IF formula
=IF([Accident today?]@row = "0", SUM(Subtotal@row + [DC AF]560), "0") I'm looking to solve, if there is a 0 in the Accident today? column, then to add subtotal from this row to value from 1 cell above in DC AF column the first row after a "1" in Accident Today is returning a zero...
How to locate information based on a percentage reached?
Hi! I want a formula to find the percentage of 53.87% that goes from 0% to more than 120%, and that returns Between 41.1% and 60% - 5% discount.
Perform operations @row then SUM together
Hello All, I am trying to right a simplified formula to do a complicated task and having difficulty. Below is the formula in question. I am trying to SUM up all volumes of some buffers that use a specific lot of 3M KCL. I also created a helper column with a factor to divide the total by based on which buffer is using the…
Multiple date range requests within a single formula
This discussion was created from comments split from: Return Value if Between Dates.
How can I incorporate 'IFERROR' in the below formula?
In certain circumstances there will be no date in both ' CAT - Date of Last Activity' & Date of Last Activity plus 7 years. Therefore I receive the error message #INVALID OPERATION. How do I add the 'IFERROR' function to the below formula to stop this from happening. I had a go but can't seen to figure it out. Thanks!…
Using GYR symbol for status nested if's
Hello, Does anyone know how I can use the GYR symbols in a nested if condition? I am using three columns, the last one using the symbol to reflect the status. Here is my logic: If column A has no text, show in column C nothing or "". If Column A has "text" AND in column B has text, show in column C a green dot. If column A…
If AND or OR
Hi, I have use below formula to show all parts of my process steps. It works well with red and green balls. But I would like to add if one of below columns is yellow (pending) the result in this cell should be yellow as well. How can I modify the fomula: =IF([Dev sample needed?]@row = "", "", IF(OR([CAD upload on time…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Formula Help: Do This Week, Do Next Week
Hi, gang! I need to create a formula that populates Do This Week, Do Next Week, Do Three Weeks for my boss. I have Start and Finish date columns as well as a dropdown Do column with those three as options. We're not looking for reports, but rather this summary view in Card View for him. Thank you for your help!
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
How to use IF and IFERROR?
I am writting the formula for counting the result of the work of my team. The result is counting from the complete date< expected date would be green and if it is greater, it would be red. However, in some cases, even i did not fill in the expected date and completed date, but the result is still showed as green. This…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags