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.

Date Formula Question
I built a sheet that includes a column for D.O.B., and another for "Age at Admission," which contains a formula. I'd also like to have a column for "Current Age" that would work through D.O.B. Not sure how to set it up. Don't think it should be too difficult, though. Any help appreciated.
Formula Help
Hello Smartsheet Community, I am trying to figure out how to write a formula to highlight individual cells based on if the "Actual" number inputted into a specific cell is greater than or equal to or less than the "Target" amount. For example, if my "Target" for the month of July is to sell 500 widgets and I actually sold…
How to import data from other sheets?
Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc. I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is: Item Sheet: select SKU-001 Sheet references…
Adding decimal places to a %
Hi all, Is there a way to add decimal places to a percentage in Smartsheets? Or is this not an available function? As of now, the percentages are rounding up but I will need to have more specific readings such as a 1.23% etc. Any input would be greatly appreciated! Bryan
parent child vlookup
Is there a way to use a sheet that has parent-child as a Vlookup for another page?
SmartSheet Dashboard Not Displaying Certain Data
Hello, I'm creating a dashboard that I want to display data directly from one specific source sheet. I'm trying to display data specifically from 12 unique columns, but certain selected columns are not displaying information, despite having data in that source column. Specifically, the dashboard is only displaying data…
Formula referencing another sheet
Hi all - new to formulas. This is what I'm trying to do... Sheet A: has list of all members Sheet B: has requests from anyone, not just members. We want to have B look at A and if a request is from a member, it states on Sheet B that yes this person is a member so they should get the discount for their request. So I need…
Two Conditions in a CountIFS
UPDATE: I just figured it out. It was a matter of the parenthesis. This is what works to compare two conditions in another sheet with a COUNTIFS in case anyone else is struggling with this. =COUNTIFS({OEM Scorecard V5 Range 3}, 7,{OEM Scorecard V5 Range 5}, "Dan") I'm trying to set up two conditions in a CountIFS formula.…
Flag setting
I need he flag to be activated when 2 conditions are met E.g if there is a value in a column and no value in another column, the flag must show
Update Requests workflow not working
I have a workflow that will send an update request to the auditor when an audit fails. It has suddenly stopped working and I have to manually send the update request. What could be the issue?

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