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.

Checkbox formula with percentage
Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you!
Formula to create a number assignment catalog
Hello, I am trying to create a number assignment catalog that is automated to speak to a smartsheet that has my full collection of products. The goal is when creating a new product anyone could fill out a form select the category numbers that will define the department and then select a a number that will identify the…
Pulling data from a sheet
Good Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that records each persons errors for the whole year. I record data for about 30 individuals…
sequential number for each parent row - column formula
Hello im trying to generate a sequential number for each parent row. I can do this using an helper column called parent that flags each parent record with 1 then the formula @row, 1) this won't convert to a column formula because of the explicit row references used to define the range. can it be done. any help appreciated…
Accounting for the word "Perpetual" in a date field when there is no end date
I am currently running this formula: =[Contract Expiration Date]@row - [Notify days to renew/cancel]@row to calculate the date when we need to review a contract. It essentially takes the end date of the contract and subtracts the numbers of days specified in the contract if you want to cancel. We have some contracts with…
Column Formula not selectable as Gantt Label
Hi Folks, Is this a bug? For Gantt chart labels, I use a column that concatenates and formats the task and end dates; call this column "Gantt Label". I select this as my Gantt label and it looks great. To prevent my formula from getting corrupted or broken, I convert "Gantt Label" to a Column Formula. Here's where it gets…
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
What criteria use to determine a "current user".
I have a report that surfaces information based on a current user filter. It is filtered on a contact column. The issue is, my users are all over the map with logon ids. We have two sets of emails in my company, internal and external. They all map to the same email client, so to the user it is transparent. In addition some…
Taking into account month AND year
Hi everyone, I have two columns. One is the date that the form was submitted, and the other tells us which quarter we received it. Our fiscal year is from April 1 to March 31. This formula works great, but I've realized it won't account for the change in year. Currently, we are in 2020/21, but as of April 1, we will be in…
Using COUNTIFS with CONTAINS
When I try to incorporate a CONTAINS into a COUNTSIFS i keep getting errors Works fine: =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA - Daily Job Start Safety Form Range 2}, $Date$1) Incorporate CONTAINS : These are 2 i tried =COUNTIFS({JSA - Daily Job Start Safety Form Range 1}, Date@row, {JSA -…

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

Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
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…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags