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.

CountIFS and Summery Date Field
Having trouble with the following formula returning an "Unparseable" error. =COUNTIFS(Type:Type, "Release", Status:Status, "Complete", Due Date:Due Date, >=[Current Quarter Start]#, Due Date:Due Date, <=[Current Quarter End]#) Can anyone provide some help?
COUNTIF and COLLECT
If the column "Graduation Year" is "2021", I want to collect from the column "Position TYPE Post GME Training" the total number of cells with "Private Clinical Practice-local". See below. What am I doing wrong?🤔 There are multiple values in addition to "Private Clinical Practice-local" in the dropdown for "Position TYPE…
Using SUMIFS with YEAR and MONTH from single referenced column
Hi all, I'm trying to create sheet that will sum up all revenue for a year, by month. End result should look something like this: I'm using this formula and receiving an #INCORRECT ARGUMENT SET error: =SUMIFS({anrev}, {vehicl}, "Site", {Scale Date}, IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1) (this is for…
Use only parent rows in a referenced sheet
I'm trying to count the number of times a text string is found in a different sheet in columns of the same name, but I only want to count if the name is in a parent row of the referenced sheet. The formula below is #unparseable. What is wrong with it? =COUNTIF({Sheet1 Names}, CONTAINS(Names@row, @cell), {Sheet1 Names},…
Match Cell Content in New (Form Provided) Rows with Content in Previous Rows
Hello I am looking to use a formula to bring an entry from an existing cell into a new row when another column in that row matches. I will be deploying a Smartsheet webform, and when the last name of a respondent matches in a new response, I want that new row to automatically contain the Dropbox folder for recorded in the…
IFERROR MONTH
#UNPARSEABLE error when adding the MONTH function. =COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4))
Is it possible to create uniquely identified numbers using level 1 parent tasks as a baseline?
Is it possible to pull the first three letters of a parent task, and then give it an unique identifying number xxx-9999? I have groups of tasks that I would like to create an ID for whenever there is a newly created line, each line would inherently be a child to parent task. For example a subtask of an "Engineering" group…
Automated RYG Balls
Hi, I'm trying to add an automated RYG light column formula with the following function: Green = [Status] is either 1) "Resolved" or 2) [Status] is "Open" and [Due Date] is in the future Yellow = [Status] is "Open" and [Due Date] is in 14 days or less (including today) Red = [Status] is "Open" and [Due Date] is in the past…
Harvey Balls for Due Date
Good morning, struggling with Harvey Balls this morning and creating a nested IF. My previous version did not take into consideration the status so as the entries aged, they eventually all turned red which skewed my metrics. I am tracking the age of invoices and want to have the following conditions captured by a harvey…
LEFT Function
I want to add a "0" to the left of any number with just 5 digits and just duplicate any number with "H" in front.

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