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.

Help with ANCESTORS function
I would like to use the ANCESTORS function to pull all ancestor information into a row, but I'm getting an error message. Please see screenshots below. Does anyone know what I'm doing wrong? If this were working ideally, it would return the value: "Editorial Review ER1." Thanks!
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
Trying to figure out how to leverage a name to autofill assigned to in children tasks.
I have a sheet where people are picking up open assignments. This is being linked to the master sheet with the Parent and children tasks. I am trying to figure out how the "pick up assignment" can auto fill in the "assigned To" child tasks once the Pick up assignment has been filled out? See attachment for more detail?
Formula for Duration Between 2 Date Columns
I need a formula for a duration of days between 2 date columns. I have no idea how to do this, as I am a new smartsheet user and not familiar with coding or formulas. Any help would be GREATLY greatly appriciated!!! Please view attached. Thanks!
Sheet Summary Formula
Hello- Hoping you could assist me? On Sheet Summary, I need the sum of all checked box "Forecast" for the status below except "Order Submitted" so far I have this formula, how to add the status except Order Submitted. =SUMIFS([Order Amount]:[Order Amount], Forecast:Forecast, "1") Cancel /Rebook Check DOP NSSR Order Review…
Need help with a formula for that sums up the amount of material used based on Job numbers
I am trying to track the amount of cans we use for each work order. Each work order has a specific number and each pallet of cans loaded has a different pallet number, our operators enter in how many layers we use from each pallet. we run thousands of work orders a year with no re-occuring work orders. How can I get the…
How to count unique values and prevent duplicates
So I want to count jobs per month, each job is assigned an 8 digit code, but each job can be worked for several days, and each of those days has the code attached so it counts all of the days as jobs. I would like to sort these by month and division (both together and separate). Is there a formula to count each job once…
Formula Assistance with Linking Sheets
Hi! I have created a sheet that uses a form for requests when my company is wanting a physician to travel. This includes what center/state they're traveling to, their home center/state, the district manager that oversees each center, etc. When a physician is selected I would like for the home center, home state, home…
How do a require a form to submit a rounded number to the sheet?
I have a data sheet (and reports) that round numbers to the nearest whole number. However, as people use the form to enter data, when the data appears on the sheet, it is not rounded, and the unrounded number propagates onto the reports and dashboards. Is there a setting somewhere to maintain the "rounding" setting?…
If 2 cells are blank, insert data from this cell
Hello great minds of Smartsheet! I have a sheet that is the amalgamation of a few others using datamesh and some forms. As such I have 3 columns where project name, project number, or task number is listed, depending where it originated from. I would like to make a 4th column called Task Origin which would pull detail from…

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