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.

IF THEN help
I'm trying to make this work but I keep getting errors. Help!I IF([Document Needed]1, =BO, THEN [Date Initiated]1+30), IF ([Document Needed]1,=LOC, THEN [Date Initiated]1+10) Thank you, Kelly
Needing Help with Multiple Logical Expressions Formula
I am working on a formula that will look at a few different cells and make a calculation. I need the formula to look at ETA to Ready = [terminal ETA] + [# of days] The [# of days] is determined by which [Terminal] So I need the formula to look at the value in the [Terminal] column, then add the associated [# of days] to…
Counting dates as entries
I am compiling a metrics page, and need to count a date field, teh automated "created" which stores date and time the row was created. I want to count a total of "01/XX/19", XX meaning i dont care about the days, i just want all of January 2019 entries. I am refrencing another sheet (hence the metric sheet), so i need to…
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still…
SUMIF Contact? Help please!
I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out? Here is what I tried: =SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value]) Screenshot attached...thanks in advance!
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Date…
To stop the Counting Counter after One Column Value is changed.
I Have a project in which i have to Calculate the days. From the date form is submitted to the time it is approved by the internal team. I want to stop the calculating counter after the Status of the internal approval is changing. The Approved Column has different drop down list which changes and and thus the count has to…
IF THEN statement in a symbol column
Fairly new to smartsheet, so not sure if I'm doing something wrong. I have a priority column in my To Do sheet which is a symbol column (High, Medium, Low). I would like to create an IF statement that will automatically change the priority to "Low" once the task is completed (doing this for the purposes of a report I am…
CountIFs EOM Formula
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format? Excel example: =COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0)) Smartsheet: =COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1)) Any help…

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