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.

If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
Vlookup
Hello, We have here 5 different sheets containing records for Medical service details, including columns for patient name, ID, DOB, charge amount, payment status, etc. Now i want to get a sixth sheet that will look up from the above 5 sheets only the rows that's stated as Denied, so i can view all denied claims in one…
Nested If Formulas with conditions in 2 columns
I'm trying to figure out how to create a formula that has a red flag appear if the following are true. I can't seem to figure out how to put the whole formula together. Any help is appreciated. Thanks! IF(AND[Due Date]@row < TODAY(), Status@row <> "Complete" 1, 0) IF(AND([Due Date]@row < TODAY(), Status@row <> “Closed”),…
Separate Data
Does anyone know how do you split data in one cell into multiple columns?
Countif Formula
Hi everyone! Im having trouble with a simple COUNTIF formula. I am getting "UNPARSEABLE" but for the life of me, I just don't know what I'm doing wrong. I want to count how many times the "Weekly Goal" was met in a range of cells. screen shot attached.
Hierarchy tagging
Greetings, I have a organizational structure that has three levels * Campaign * Project * Deliverable * Task I am trying to figure out a way how I can have a column with one of the above values that is based on hierarchy. I have the project and deliverable part figured out using the following formula:…
IF function 100% Complete
Hello, I'm trying to figure out using a symbol column type, once the visual symbol of a checkmark is selected, to then have the % complete column populate "100%". I can't seem to figure out the correct function to apply to all cells under the symbol column to automate this action. Any help on accomplishing this is greatly…
Count Checked boxes from another sheet
Hi - I've seen this question a few times, but I am still not able to get this to work. I have a Metrics page that I am rolling totals up to so I can display a donut chart of projects per GEO. This has worked, up until now, because I have a single column as a drop-down to show these metrics. =COUNTIF({Geos}, Metric9)...I…
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
Countif, isdate, weeknumber
Hello, I'm trying to write a formula that will count rows containing a date that is part of the current work week. The date column has non date values in a few cells which seems to be throwing off my formula. This is what I have so far; =Countif([Due Date]:[Due Date], AND(isdate(@cell),…

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

Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
AND-OR-COUNTIF Question
Hi, I started to build a formula and it doesn't return the required values. I have a sheet for distribution board testing. There are 25 yellow checkbox columns and 24 green checkbox columns. I have a column with 4 colour symbol (L1-Quad), and a checkbox column (All DB Tested) where the formula needs to return the value. My…
Formula produces #CIRCULAR REFERENCE
I'd like to compare the dates in two rows, i.e. Ende (Plan) and Ende (nach Verschiebung). If Ende (Plan) is older than Ende (nach Verschiebung) the date should change to red colour (or somehow be highlighted). The AI tool in Smartsheet proposed the following formula =IF([Ende (Plan)]@row < [Ende (nach Verschiebung)]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags