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.

Using ISBLANK with schedule health function
Hello, I'm using the below formula to calculate schedule health. The schedule delta is based off calculating the difference between columns Target Start Date, Target End Date and Actual Start Date, Actual End Date. =IF([Schedule Delta (%)]@row > 0.25, "Red", IF([Schedule Delta (%)]@row < 0.1, "Green", "Yellow")) It works…
Multiple IF/AND/OR/ Functions
Hi! I thought I had figured this out... but midway through making changes, realized that it's still not working quite as effectively has I thought. I'm currently using the below formula to change the Offer Phase parent row from "In Progress" to "Complete" if the following conditions are met: If the Offer phase in row 770…
Nesting a formula in an 'if' statement - conditional values
I have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column. I'm trying to use in a IF statement to behave in the following manner and can't get the syntax right. I'm striving for, in…
Summing up just the parents
want to do a summary field on a smartsheet that has a month for each parent and the children are transactions under each month they occur. each parent has a column (same column as the children) that has a total for the children. Without adding new columns to designate this is a parent, this is a child. Is there a formula…
how do I display the highest condition from the child cells in the parent cell?
for parent I the cell (1, 3) must show "Urgent) and for Parent 2 the cell (1,9) must show "Action"
Minimum of a certain range
Hello, I'm trying to use a formula to find the oldest date for a certain range of rows. Is there a similar MIN function as there is to SUMIF or COUNTIF? Or some similar work around? This is my attempt, but it does not work: =MIN(IF({PM Sheet Region} = "TQM", {Column of Dates Here}))
Form sheet that gets cell linked to another summary sheet
I have a sheet that gets fed numbers from a form. The form will get filled out daily. I thought I had it all figured out-- I had the form add the newest entry row at the top and I linked those cells to my summary sheet. But then I realized that there was no way to make the linked cell link to an absolute row value, it…
Multiple IF/AND statements
Hello, Trying to combine the following formulas based on changing criteria and not sure how to put them together. Each one works on it's own but as soon as I try to add another one I get an #UNPARSABLE error. IF(AND([Vendor Assignment]@row <> "", [Window End]@row = ""), "Vendor Assigned", "") IF(AND([Vendor Assignment]@row…
Can you use CountIF if there is more than one term in a cell?
I have a sheet that is updated from an export from another system. One of the fields in the other system is for category and can have more than one category selected. So when the data exports it appears in Smartsheet as "Category 1, Category 2" - separated by a comma. I want to count all the rows with Category 1. Is there…
Duplicates from Excel
Hey Guys! I am wanting to count duplicates from a dump in Excel for one column (Supplier Id). I know my formula is correct but it seems to not be counting correctly because either 1) the tick mark added to the beginning of the number from Excel or 2) the amount of zeros? Any ideas to fix this? Formula: =COUNTIFS([Supplier…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags