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.

Extracting Numbers from a Cell Containing Both Text & Numbers
Hi All - I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will not convert the cell contents into scientific notation). I need to remove the '$ text from the cell, so I can sum the value…
simple total column
I have set up 2 sheets similar to the inspection submissions and metrics template i found in the solutions center. I use it to collect postage cost per month. I have the submissions feeding into the metrics page with a SUMIFS formula. All of that is working fine. However when I want to total the row for a monthly total…
SUMIFS Formula unparsable
Hello, My formula below keeps coming back unparsable and I can't figure out why...The column I need to be summed is referenced first in Range 2. I am also referencing the same date column for that Month and Year criterion. It's on the tip of my tongue but I am running out of options. Any help here would be wonderful. I…
Setting flag when task falls within a date range
At my company we have certain dates when we do not make changes to our website (holidays usually). I'd like to be able to highlight or somehow flag a task if it falls within one of the freeze date ranges. Is there a way to do this?
Report Not Updating
I have several reports setup to filter a sheet by status and up until today everything worked fine. Now, when the status changes, the report doesn't get updated and I don't understand why. For example one of the reports filters for a status of "Design" and when I perform the necessary steps to move it out of the "Design"…
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
Modify scale on an axis of a graph
Good Day t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible? regards
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
Issue with Nested IF Formula
I am having trouble getting my nested if formula to work. I have the following formula: =IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([Days Open]@row >= 100, "Red", IF([Days Open]@row <= 45, "Green", "")))) It is working for all the cells except the blank…

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