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.

Gathering information from another sheet, if information not on that sheet, gathering from another
I am trying to figure out a formula that will allow for me to gather information from multiple sheets (not a sum). We have multiple logs (one for each year) and i am trying to link all of this data to one sheet so it needs to look at multiple sheets for the information. I am currently only linked to one log and this is the…
How to copy and replace data using automation
Background: I have a sheet with a list of projects and their monthly savings actuals+forecast (Jan thru Dec) and prior forecast (Jan thru Dec) where prior forecast is last month's actuals plus forecast. Between the 1st and 10th of every month, project owners will go in and update actuals for the previous month and forecast…
Successor Column
Hi Brain Trust We have a sheet using predecessors and have just been ask if we could have a Sucesor column - iIt would be good to know when amending a date what other items are dependent on that date
Cross Reference Two Sheets
Hi I am very green smart sheet user and I need help typing up a formula. I want to reference emails in a column from one sheet called "Active_Master Contact Sheet" in the column "Email" and enter that email into my "World Series Master Crew List" in the column "Personal Email" I am getting hung up on how to make that…
Time and Date calculation
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted is still in the "Pending Status" I have the following column available I wanted to show the current duration in hours that…
How to COUNTIFS with multiple criteria
I am trying to create a COUNTIF formula with multiple criteria. I have created a functioning formula for each condition but it stops working when I combine them together. In the example pictured, I would like to count the number of occurrences for each proctor when the duration is greater than or equal to 05:00 (and then…
=Rounddown( not rounding down
Hi All. I have two cells Text/Number each and looking for the average of, but regardless of how I construct the formulas I end up with 35.700%, What I want is 35.7%. Results cell is formatted to % and to the lowest allowable decimal. Have I missed something? =AVG([Total Activations Yr24]@row, [Completed design tasks]140)…
How Does Smartsheet Handle Duplicates in INDEX/MATCH? Sorting for Accurate Results
This discussion was created from comments split from: INDEX and MATCH across two sheets: a detailed explanation.
Can we Capture Time?
Hello Team, Is it possible to capture time? I need to create a logic to order automations thru time, I have added the column to get the Date and time, now I need to add another column, that will grab the time on the created date column and after 1 minute, one automation is flowing and another one after 2 minutes. I have…
Calculate Number of Deals on a Waitlist at a Given Time?
Hi, For context, a buyer and seller will approach my team and provide us with a proposed close date of their deal. Often times our deal teams are finishing up other deals and cannot immediately start working with them. We create a Salesforce opportunity and add them to our "Waitlist" (category in SF opp). Sometimes this…

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