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.

Days Duration Calculation Based on Criteria
Hi all, here's my scenario. I have four sets of cars that get moved out of my location. They come sporadically throughout the month. Im trying to figure out a formula that would average the turn time on a particular set of cars. Any ideas? Sample Below 8606 05/01/20 340200 05/02/20 8606 05/04/20 340200 05/06/20…
Formatting numbers like in Excel
How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.
Yielding blank cells
Hello, I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not yet started, because the start date has not yet started or is not yet set, to remain…
Can I hide rows using a condition?
Hello, Is there a way for me to hide rows if one of the cells says "completed" by using a conditioning format? If that is not possible, is there a formula that I can implement that would get the job done? I am managing a photography team and they have expressed the concern of seeing too much on their sheets that would…
Date and SUMIF or SUMIFS formula
I am needing help with the following formula. This following formula sums up by the month but I need it to sum by month AND year. For example, add up all January 2020 and then February 2020...etc. Any help is appreciated. =SUMIF({Production Credits_2020 Range 12}, MONTH(@cell) = 1, {Production Credits_2020 Range 16})
Automate UAT Test Script
I am looking for a way to create a test script using forms. Multiple users would complete the script which would populate a single sheet that could be reported off...... If a tester completes a step in the script (form1), they would submit/save and it would call the next step (form2), each form when complete would save to…
If Statement - Referencing Symbols Column and Text Column
Hello, Here's my IF Statement where I'm receiving an "Incorrect Argument Set" error. If my Active Status column (symbols) shows a blue circle, I want to return the value in Text Requested column. Otherwise display a zero value. What am I doing incorrectly? =IF([Active Status]@row, "Blue", [Total Requested]@row, "0") Thank…
COUNTIFS based on conditions
Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH. I have all of the data in 1 SS and am totally and running metrics in another. In the sheet I'm running the metrics in I have a row for each cohort, and where I want the count to…
Index Match only returning first index option?
Hi, The Goal: Use index match to return a column name based on which column in a given range has the maximum value of that range. The problem: I can only get 1/5 of my return options to work, and only when I add 1 as 'column index' field to the Index formula (usually column index is optional- I've never needed it in any…
Formula Help!
I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with: I need to search one column of information for any input values for only the past two weeks IF a…

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

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags