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?
Sign in and 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.

Formula to return the SUM of prices from a cell with multiple values (multiselect column)
Hello! I'm sure someone has encountered this issue before so hopefully there's a work around it. We have a tracker with multiple service requests. We document each request in a very detailed way here. We already have a lot of columns here, so adding more than 2-3 is not an option. From a multi-select column named…
How to view tasks assigned to me?
Hello! My team uses several different project plans & there is a specific line on each individual project plan that is always assigned to me. Is there a way that I can keep track of those tasks assigned to me in one place? I created a report, but that requires me to link in every single project plan as the request comes to…
Sheet Summary Question
Hello all, I am trying to do a sheet summary to show the Active Dealers vs Non Active Dealers that are running campaigns. An active dealer will have a monthly total greater than 0. However the Monthly Total Column in the smartsheet is a referencing information from another smartsheet using a Vlookup. I am trying to do a…
General Income and Expense Sheet - Referencing Cell above, and using Column Formula
Hi Everyone, Basically trying to create a basic income and expense sheet, moving from Excel. Where the first row, has a fixed value and the rows after will have a formula of balance from previous row - payments from current row + deposits from current row. The formula is dragged along the Excel sheet. Excel has only 3…
each rows has different conditions, in a single cell ?
each row has different conditions, In a single cell I need to enter all the formulas for different levels of each row? please help me. Thanks in advance.
Count of cells in the last 60 days with a specific status
Hi. I've been at this for hours and can't get it. I'm trying to write a formula that will pull a total count of items with a specific status for the last 60 days. Both of the formulas below work separately, but when I try to link them with an AND, it breaks. How do I link these two statements? =COUNTIFS([Enablement…
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
Issue combining multiple cells in one sheet
I am trying to combine 4 numerical cells in a single sheet into another cell/different column in the same sheet. When i do this it is creating a sum of the first two cells and combining the rest. 1 1 00614 100 Outcome is 200614100 Formula =JOIN([Grouper 1 (Entity)]@row + [Grouper 2 (Type)]@row + [Grouper 3 (Numerical…
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…
RYG formula with Open date
Hi Everyone - I'm looking to used RYG for project health, Comparing Requested Completion date with Actual Finish Date. The formula works - except when there is no date entered into "Actual Finish Date". =IF([Actual Finish Date]@row <= [Requested Completion Date]@row, "Green", IF([Actual Finish Date]@row > [Requested…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Display formula result in form
Hi, I have a column formula that grab a link from reference sheet and I need this to be displayed before submitting the form. Example, column A is a drop down of items, each of these items can be downloaded from a shared link. So in column B I added a formula to grab the link from referenced table. However in the form I…
Trying to put a value into a cell that is returned blank from formula.
I've created a column formula that returns a value from another column if it has a value in it; if that other column does NOT have a value, it returns a blank cell. =IF(ISBLANK([Print Quantity (if known)]@row), "", [Print Quantity (if known)]@row) The formula works just fine, but I want to be able to type in a value to the…
CountIF won't recognise the result of a formula
I have a column that contains a column formula driven from a date. GRID COLUMNS Detection Date = DD/MM/YY Year = formula: =20 + RIGHT([Detection Date]@row, 2). Result = 2023 Sheet summary This Year = formula: =20 + RIGHT(TODAY(), 2). Result today = 2023 Breach This Year = formula: =COUNTIF(Year:Year, [This Year]#). Result…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags