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.

Return first NOT BLANK field in a column and first BLANK field in a column
Hi, I have a column with a formula that calculates the Current Step Calc in a process based on there being a date or not in a Task Started column. That part is working fine. My results look like this in the Next Step Calc and Current Step Calc columns What I'm struggling with is a formula in the NEXT STEP column that will…
Look-up formula to reference data in another sheet
I am looking for some help with a formula that would look up a resource name and pull their total departmental allocation for a given month into a another sheet. Here are screen shots of both sheets - the one on the left is where I want it to find the highlighted # and drop it into the cell on the sheet shown to the right.…
Calculating a Running Balance
Hello, everyone! I'm currently working on an inventory system that is linked to one "Master Inventory" sheet. I don't know how to best create a "running balance" so that every time an item is scanned and an order is generated, the item's "Master Inventory Record" is deleted accordingly. Here is an example of the "Master…
How to make multi-select selections be clickable links (in a report or dashboard)
Hi there, Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report or Dashboard. To elaborate, I'd like a Report to have each selected item in a…
How do I link 2 sheets for calculating time off (Vacation Day or Sick Day)?
This sheet is the results sheet. This sheet is the information used sheet.
How do I create a summary page or report from a Financial Donor List?
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and the total amount they have donated. Also, is there a way for a new donor to…
formula in sheet summary = unparseable
Hallo, I use following formula in the sheet summary (the header is not very helpful - I know ;-) =COUNTIF(Status:Status; =[Vorgang gelöst (warten auf Rückmeldung)]) / even with " " Any idea ;-)
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
Resetting week-1 networkdays dates based on week-2 day of the week
Hello All, I'll try and explain this without confusing everyone :) I'm building a travel calendar that project managers will fill out every Thursday for the following week. I'm using the PM's name in the parent row and dates in the child row and would like to use networkdays if possible. I don't want to create dates for…
Need formula to pull data from Last week Sun through Sat
The formula below is working perfectly pulling the time Laura Spent on Projects, year to date. Now the boss wants, instead of year to date, he wants to display only Dates from the previous Sun - Sat. So we want our graph to always show the data for LAST week. So no matter what day I'm looking at it THIS week. I want to see…

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