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.

Automation based on date
Hi, I'm looking for a formula that can be used to automate sending out a reminder based on a certain date for every X number of years. For example, I have an "invoice due" date column, and then a column next to it saying "number of years." That number of years can be every (1) year, every year for two years, every year for…
Hi, I would like to count the occurrences in the current month and previous month. We use Australian
Hi, I would like to count the occurrences in the current month and previous month. We use Australian date format. I have tried IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), but this is not giving accurate information.
Compiling Inventory Data Living Across Multiple Columns
Hi everyone! I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into…
Random Updates - Cell History
Hi, we've been using a format where once a form is submitted, a row is copied to another "master" sheet that the team can manage off of. Recently, I've made some changes to the process (around when the copying happens), but what we're seeing is that in our Master sheet, there are random updates to cells (we have alerts set…
Refreshing Data after Form submission
I have a sheet which is populated daily using forms. The data from this sheet feeds into a dashboard which displays the number of entries that day. This metric comes from a cell that uses the "COUNT" formula to record the number of daily entries. Everything with this works fine but the problem I have is that when a new…
Checking if a box is checked.
In general and specifically, how do you check if a symbol is in a cell, like a check mark? I am setting up a formula that checks if a well site has been inspected denoted by a check mark in a cell for a pad row.
How do I pull risks and issues from multiple projects into another sheet?
I am trying to create a programme view over a number of projects. I want to be able to gather all the risks and issues from the various project raid logs into another sheet so, it can be displayed on a dashboard. How is the best way to do this?
Sum Column results when filtered
I want to sum numbers in a column of all the vendors. If I filter out certain vendors I want the sum to be only of the vendors showing. How do I do that?
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
How to create an average using SUMIF as the denominator
I am trying to create an array of construction costs then extract the square foot costs. The issue I have is not all projects have the scope of work. For instance, I have new lighting on some but not all projects. So I want to create an average using the the total costs divided by just the cells that have square footage…

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

Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…
Duplicates in formula-generated column
I use formula =IF(COUNTIF(Column:Column, Column@row) > 1, 1) to find duplicate values within a column. However, this formula does not work if the value of the source column is generated by a formula. For Instance, ColumnC = ColumnA + ColumnB. The above referenced formula does not work when trying to find duplicates in…
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…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags