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.

Milestone Report
How do I get this calendar on the right no to show? I'm using a report to pull this info This is what my report looks like
Equals ?
What is the formula for equals? For instance, how do I get the value in the Start column for Task 3 to also populate in the Start column for Action A ? In Excel I think it would just be an equal symbol and cell position like =C3
Can Smartsheet AI identify all rows that are associated to a similar issue?
Working in a ticketing system. I would like to use AI to look at each ticket problem description and be able to group "like" tickets. Is there a way for AI to do this? I wasn't able to find an AI command that worked for this.
Issue with formula (Contains, If and or)
Hi, I cannot seem to get this formula to work — I want to flag any requests for rapid ads (ad request type contains "rapid" for two types of classifications (class type contains "mgr" or "sup"). This is what the formula looks like but it is not working properly so I know something is wrong… any help would be most…
Default one field value based on item selected in another fields dropdown
Hello, what I am trying to accomplish is in a PMO tracker we have a field that has a list of drop down items based on the type of Project Request IE New, Enhancement, Breakfix and need an associated field to default a value to support resources processes. (sorry very new to Smartsheet)
How do I eliminate the column name.
How do I get the "column6" or "column7" not to show up? I know I can delete the actual text that says column but the space is still there. I copied these four cells in my metric sheet us the metric widget on on the dashboard.
Combining Data
Hello, I have two sheets within a folder. I would like to be able to automate the combining of the data from these sheets into a new sheet which I could think use to build a report. Is there an easy way to combine the data? The sheets have different columns so replacing the data is not needed.
Formula Help
I have column with tittle Cost Center (CC), I need to create a formula to pick up 8 cost centers ID and flags in another column. The idea is to identify these 8 values as they need to be modify prior to another process taking place. I have tried the HAS and IF(CONTAINS) but unsuccessful in string - For example:…
how to automatically set a number to an entry
Hi All, I'm trying to make an equation wherein if I type "Critical" in column 1, column 2 then will automatically assign it as "priority 1"
MAX Formula for Cells?
How do I get the MAX date from a few cells? For instance, how do I write a formula to pull the latest Finish date from Task 2 through Task 5 ? Secondly how would I write it to pull the latest Finish date for Task 1, Task 2 and Task5 ?

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Subtract 1 month from the date expire for a task
I have a column that calculates a due date that uses this simple formula: =DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row)) It works great but for some reason returns #INVALID VALUE when the date expired is any day in January. any other month seems to be fine I'm guessing because the…
Count(Distinct(Collect Help
Hi All, I'm trying to count the number of 'distinct' participant to events based on the year and add that count to their org leaders. In the table where I have the participant I've alredy added helper columns to identify their leaders at different lvl. My formula works fine as long as I point to the specific column where I…
Formula for Index/Match Multiple Criteria
Can someone help me with an Index/Match or Index/Collect formula to accomplish the following logic? When {ArchiveCSYYXXXX} = CSYYXXXX@row AND {Task} = "Final Signed", provide {FinalSignedDate} In case it's relevant {ArchiveCSYYXXXX} and {Task} are child rows on their sheet. Thanks so much in advance!

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags