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.

Automating R/Y/G/G Formula for some colors
Hello - Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column. My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray. I am looking to create a formula that enters a 'Gray' icon when 'Completed'…
How to start counting the number of days up from a [Start Date] column, but ending it when the job i
Are you able to provide a formula that will for for the following: to start counting the number of work days up from a [Start Date] column, but ending it when the job is completed (whether is be an action or another date is reached)? Much thanks
Need Formula to count if cell values are Greater than 0.5
I have tried several different formulas to determine how many cells have a value greater than 0.5. The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8. The cells are not next to each other so it can not be a range. Any suggesstions? Forrest
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
Formula for addition of quantities
Good afternoon, I am attempting to create a formula that adds the sum of multiple quantities. How would I create this formula and assign values to different types of information within this formula?
Unparesable Error
Receiving unparseable error when selecting a field in one column and wanting a specific result in another field. This is the formula. What am I missing? =IF([Submit for Approval]1,1[Manager Approval]1 = "Submitted") See attached
Formulas
Hello, I am needing help with this formula =IF({Colunm Range 1} >= 10, "Met", "To be Started") (this works but will not be relevant for the whole year.) How can I add in a date? I was this formula to recognise if a range is equal to or great than 10 after the 01/03/19, "Met', "Risk" Also can you AVG Harvey balls at all????…
Reference a Report
I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked. Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user…
Symbol Formula
Good morning, I am inquiring about a formula that adds a quantity of certain symbols within a sheet. I would like the total of check marks to be added. Attached is a screenshot of what I have unsuccessfully attempted thus far. Please let me know what changes are needed. Thank you
IF Statement Help
Hello All, I am trying to create a smartsheet to optimize a process. Basically what I need is a statement to recognize if a cell has a specific text value (for example CUP). If the cell contains the value, I need the cell, that I am writing the statement into, to display text (for example Andrej). I tried to use the IF…

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