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.

Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
Risk Assessment formula conversion from excel to smartsheet
I'm trying to convert an excel formula to use in smartsheet without much success. The excel formula is: =IFERROR(MATCH($F4,'Lookup Table'!$B$3:$B$7,0)*MATCH($G4,'Lookup Table'!$B$3:$B$7,0),"") In short, I need the 'Risk Matrix' column in smartsheet to show the score where the probability and impact rating intersect. I…
Date cell is not calculating correctly
I have a sheet where I want to add 30-days to another cell that is a date. I am using the formula: =(original date cell) + 30 Example: The original cell has a date of 3/19/19. I should get 4/18/19. However, I'm getting 3/19/1930. I have cleared the cell contents, deleted the row, and whatever else I can to create a clean…
Formula RYG automation with using Complete% and rest of date by end date.
hi I'm trying to create Formula. It's almost completed. However, one last rule doesn't work. Can someone suggest to modify my formula? Currently the following conditions and formula is working fine. - If Complete% is 100% = Green - If Complete% is upper 60% = Green - if Complete% is under 60% and Today is less 5…
Date ranges and symbols
I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signify about the expiry date column - Green dot = If the contract expiry date is greater than 365 days from today Yellow dot = If the contract expiry date is less than 365 days away from…
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
Hotkey - Ctrl "R"
Hello Smartsheets Community, I am aware the developers tried to mimic Excel's functionality as much as they were able to, but a fundamental hotkey I use in Excel is "Ctrl" + "R", which allows you to copy any cell to the right of the selected cells very quickly. When I attempt to do this in Smartsheets, my browser (Chrome)…
Help with #Invalid Data Type Error
I have a RYGB column (Color Status) that has a formula =IF(AND(Done@row = 1, [Parent Check]@row = 1), "Blue", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 240, "Red", IF(AND([Days Open]@row > 119, [Days Open]@row < 240), "Yellow", "Green")))) which is working to give me the red, yellow, green or blue ball. In…
Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in…
Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it. In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of…

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