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.

Assigning a date to a value
I'm working on a gantt chart that is tracking teams progress on a project using agile development. Business Case / Background: When the teams provide updates to when a task is going to be completed, they reference the name of the sprint we're in. So for example if "Task ABC" will be completed in Sprint 1A that means its…
CountIFS- Name + Status
I am trying to enter a formula that will count when the name Kara is listed and the status is listed. I keep either getting an error or it will double count. Please help. The end goal is to find ou how many each person has in each status listed. Example: =COUNTIFS([CSMNAME]:[CSM NAME], "Kara", Status:Status, "Locked")
Nested IF/AND
When I check Declined Date, it is not changing to "Declined". Can someone help? =IF(AND(NOT(ISBLANK([Submit to Design Agency]8)), ISBLANK([Submit for Approval]8), ISBLANK([Approval Date]8), [Declined Date]8 = 0), "Submitted to Design Agency", IF(AND(NOT(ISBLANK([Submit to Design Agency]8)), NOT(ISBLANK([Submit for…
Formula to count instances of a word
I have a sheet that is referencing another sheet to provide counts on instances of certain values in different columns. What I'm stuck on is counting how many times a single word is used if other text is in the same cell. For example if I have a column call Fruit and I want to know how many cells contain the word "apple"…
Alert Rules
Is it possible when more than one row having same value( duplicate row is submitted) an alert message goes to the user that row already exist something like this..?
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
Sorting a sheet when opened
Wondering if there is a way to sort rows of a sheet on open. Otherwise you have to set this up manually each time. If this is a smart sheet you would think it would be able to do this.
Combining AND with OR
From a logical perspective, I'm trying to write a formula that says the following - If the (Issue Type = 'BUG') AND the( Status = 1 of 5 possible values), then the cell value should be a red ball, otherwise, the cell value should be green. Regardless of what I try to type, I'm either getting #UNPARSEABLE or #INCORRECT…
Help with IF / Then, or something like it
Hi Everyone, New to smartsheet and need some help. I'm trying to calculate a date in the future, only when the manager approval column is Approved. I've figured out the date formula, thanks to another discussion, but I'm unsure how to incorporate that into a nested IF, or if that's even what I need to do here. So have a…
Should I use a Report or a formula?
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a formula.

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

Replacing NULL in a column with zero
I need a formula(s) to use that can replace "NULLS" in a worksheet with zero or replace nulls with "Blank". One column contains text values and the other column number values A formula to replace "NULLS" with zero in a number value column Another formula to replace "NULLS" in a text value column with "Blank"
Form: Require "Need order by" field to be AFTER today.
We have a form that has a DATE field called "Need Order By" so that the user can tell us the date the the order must be fulfilled by. Can you guess what date users MOST OFTEN use? Yeah, you got it! a date in the PAST. We are very anxious to find a way to force the user to input a date that is in the FUTURE. Can anyone tell…
How do I pull the second name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to three contacts (first name + last name), for example Jane Doe. I then have three other columns that pull the first contact, the second contact and the third contact. The first contact column is Project Support 1 and the formula is =LEFT([Project…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags