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.

nested ifs with greater than less than- #unparseable
Wrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Yellow", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), "Green", "")))
Can I Auto Assign Tasks to Myself?
When creating a new task can I have it automatically assign it to myself?
do not run formula if cell is blank
Hello, I am a new Smartsheet user. I have search some previous inquiries on this topic and tried the suggestions but I cannot seem to get it right. What do I need to add so the formula will not run if the check-in and check-out dates are blank? =NETDAYS([Check-In]1, [Check-Out]1 - 1) Thank you so much for your help.
Combining "IF" formulas with "IFERROR" formulas
I am attempting to return a simple YES or NO if a company I have is in another sheet. I created a match formula in one column and in the adjacent column, I was hoping to do a simple IF statement to return the appropriate results. Due to the companies which did not return a match being populated with a #NO MATCH error, I am…
Determine entries in a dropdown from a formula
Does anyone know if it is possible to select each item in a dropdown where you might have one or more entries, and separate each one in a formula to calculate hours * rate? Or a work around if possible. My current formula works fine for one entry as follows with the [Assigned To] column: =SUMIFS({KCPL Hours _#OF HOURS},…
Help using join & collect function with multiple criteria & having the delimiter be a semi-colon and
I've been able to successfully use join and collect function with 1 criteria, but not two and am also curious if I can have the results within a cell space to look like Ctrl+Enter was used after each one to be able to easily read through all of the results. Working formula with 1 criteria: =JOIN(COLLECT({Product Roadmap…
Extract LowerCase initials from name in single column
Need to get correct formula/function to execute the following: PREFIX: PKS- Name Column: JOHN DOE ID Column: 00123456 Desired Formula Output: PKS-jd-00123456 Here is what I have currently: ="PKS-" + LOWER(Name204) + "-" + ID204 and the output is: PKS-john doe-00123456 OR ="PKS-" + LOWER(LEFT(Name204) + "-" + ID204) and the…
Date Problem
I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept getting error messages or other strange results. It would be nice if Smartsheet could…
Linking & Formulas
I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to each of those projects. I have 1 master smartsheet which houses meeting information,…
Troubleshooting formula and or row
I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= Today@row - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why this is the case. Does the master sheet need to be purged for underlying errors of some kind. I can't duplicate the error…

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