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.

How To Reference Top Parent For Each Row
I'm trying to implement a formula that will reference the name of the rows Top/First Parent for each row. I have reviewed other threads on this and have not seen a definitive solution (or just one I could get to work). Ideally looking for something that could then be used as a column formula. Our sheet is organized into 7…
Automation-Date in the past
I have a column named "Shipping Date" and then, a second column with a formula that gives us a date 5 weeks prior to that "Shipping Date". This second column triggers and automation to contact the customer once the date is reached. What if the line is entered and the 5-week gap is a date in the past? How should our…
Please could someone kindly help fix IF/INDEX/MATCH formula
Hello I need a little help if possible Original Formula: =INDEX({Jira MMP's Validation Results - Jira Status}, MATCH([Req ID]@row, {Jira MMP's Validation Results - MMP ID}, 0)) Which worked perfectly to change the status in sheet 2 to match sheet 1 if REQ ID and MMP ID matched, but this is when there was only a single set…
countif
how do I do a total count of PPAP rejected and PPAP approved along with adding blank cells together if the FAI Report or PPAP column says PPAP?
AVG COLLECT GREATER THAN VALUE
I have a formula to calculate the average amount within a sheet. I want to change the formula to only collect and average any amounts that are >£10,000. =AVG(COLLECT({Archive Sales Amount}, {Archive Sales Stage}, "4 - Closed Won", {Archive Sales Level 1}, "1")) Thinking I may need IF and @cell but it keeps giving me…
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
Formula to Count Number of Rows that meet a condition in 1 column and another column
Hi, I am trying to write a formula to count the number of rows that meets the following: Looks at a column called "Project Approval" and finds rows that contain a value of "Approved" AND looks at another column called "Project Status" to exclude "Completed" I am also creating this formula in a sheet that references the…
Countif across sheets, is what I am trying possible?
Good afternoon, I have no idea how to describe this accurately. Basically, On the intake sheet, when people fill-out the form, there is a column that will list the site number of the property they are at. That column will show number designations from all three branches. I want to use this section of a metrics sheet to…
Help with COUNTIFS
Hi Community! I am hoping someone can help me figure out how to correct this formula or create a new one. I want to count how often the regional VP’s name appears in a row with a date within a specific date range (quarter). Current formula I am using in a calculation sheet and referencing another: =COUNTIFS({TLH User…
How do I create a formula to calculate the number of days between two dates, excluding weekends?
I'm trying to calculate the number of working days between two date columns in Smartsheet, but I want to exclude weekends from the count. Is there a specific formula or workaround that I can use to achieve this?

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

VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags