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
Sign in and ask it here! The community's got your back.

📈 Wondering if there’s a problem?
Check out the Status Page and subscribe for notifications.

💡 Share your knowledge!
Help others by answering questions.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Set checkboxes for all children - multi parent heirarchy
I want to set a checkbox for all the children through multiple heirarchy based on the value in another column. If you look at the attached examples, if the parent value for active is N/A then that row and all it's children should be checked, including any parents with children within that heirarchy. I have three additional…
I am needing a sub for A "SUMPRODUCT" formula I use in Excel.
I have costs and associated QTY's hosted in a separate sheet. The "A*B=Total" column I just added here to help explain what the "=SUMPRODUCT(A4:A10,B4:B10)" formula nested in E3 is performing. I could easily add additional columns in my smartsheet and then just run a formula to total the columns but I was trying to keep…
Date format on charts
Hi there, I want to track the amount of tasks / date. When I convert my report summary into a chart I think the dates are reformated into numbers. My data set looks like this: And my Chart looks like this: As you can see there is an issue with the date format... I've tried everything but couldn't find a solution. Thanks…
Countifs or sumifs or something else
Hi there, I am trying to count the days in the Lost time Days column, with the month being 1 and the site being offsite. Can you pleases help me.
Auto Send Email Template
Hello guys, I'm trying to build Hiring Candidate Process so I want to build an automated sending email with a premade template, can smartsheet do that? for example: 1st interview => fail => send "thank you" email Thank you very much, hope you guys have great day
Calculate the difference between dates & Times
Hi, We use smartsheets to log support queries. I want to calculate the turnaround time between two dates: Date the ticket was loaded and date that the ticket was closed Date format: mm/dd/yy x:xx PM or AM Is there a way to calculate the turnaround time?
Adding N/A as a dropdown so that it doesn't display 'Invalid'
Good day, I want to add not applicable as 'N/A' on a dropdown to this formula such that it doesn't display 'INVALID'. Grateful for any help. =IFERROR(IF(ISBLANK([Expiry Date]@row), "", IF([Expiry Date]@row <= TODAY(), "Red", IF([Expiry Date]@row <= TODAY(90), "Yellow", IF([Expiry Date]@row > TODAY(90), "Green")))), "")
Vlookup email name return name
If I enter email from drop down list in PDCA, match that to column 3 on email worksheet and return the name to the left in PDCA Person Responsible.
Cross Referene formulas error
Hi, Can you explain this error in more detail? I've got +-600 customer sheets that does a vlookup from other sheets. I've now ran into this problem, but I'm not sure what the problem is.
I am coming up with formula errors when trying to make the parent flag red if any children are red
The CHILDREN have, for example, =IF(AND([End Date]323<TODAY(),[% Complete]323<>"1"),1,0) and that works to turn flag red in all children but tried all kinds of COUNTIF formulas to also turn the parent red if any one or more of the CHILDREN are flagged red but all attempts are failing. Any ideas?

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Help with converting inherited Excel Formula
Hello, I have inherited this formula from an excel sheet that i can trying to get working in Smartsheet however as a novice... i am struggling. Grateful for any support. =IF(M10<=5,"Low",IF(AND(M10>=6,M10<=11),"Medium",IF(AND(M10>=15,M10<=25),"High",IF(AND(M10=12,K10=4),"High","Medium")))) Protonspounge
Help with a Harvey Ball formula
Hello everyone who's smarter than me: I need a formula to result in the following: Field empty if no start date listed Green ball if complete, regardless of start date Yellow ball if not complete and start date is within the next week Red ball if not complete and start date is in the past Gray ball if start date is more…
Revise Formula - RYG
I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red") However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags