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.

Question on auto-population between sheets
I am trying to setup some sheet automation as follows: Program Manager sheet: Tracking ID is auto-generated using auto-numbering When a new tracking ID is generated would like to populate that new ID into another Master worksheet into next available row Then that Tracking ID would be populate into individual program…
Simple If with @row - Why won't this work?
Lookup / Return Cell (contents)
I need a formula to look at @column1/cell (whatever it is); go into another sheet, find that match/@column1/cell, and then return what is in another column (in the 2nd sheet). Hopefully, that isn't confusing............
Hello - need help! :) Summing data from multiple sheets.
Hello I have 5 sheets of many cells of data for different work groups within my organization. I need to create ONE summary sheet that totals each of the cells from the 5 sheets. The only way I can figure out how to do it is by creating the =sum( reference another sheet) five times for each cell... it will take me…
HAS Functions Returning 0
Hi Smartsheet Users, I am struggling with the formula HAS with multiple selection drop down values and hoping I could get some guidance here. Here, i would like to count how many "swimming" classes I have in a week. The expected result is 3. In the sheet summary, I have the formula written as…
Drop Down List
Q: Is it possible to assign a drop-down list to a single cell and not the entire column?
Can I verify each entry in a multi-contact list exists in a different multi-contact list?
I use Dynamic View. Dynamic View, unfortunately, only allows 1 single column to be the list of users who can see data in a specific row. Smartsheet is not able to combine multi-contact lists into a single column that is recognized within Dynamic View. (I can combine multi-contact lists however, e-mail addresses listed in…
Formulas on forms
Hello, I have question do you know how I can use the same "formulas" for each new ligne generate by the form ? The formulas has the purpose to take information from another cell. MT for your help. I tried this tutorial but it does not work with forms :…
Allocate hours into months based on given date range
Hi All, I want to allocate hours equally based on a given date range, in excel I could get it work using Eomonth, in Smartsheet, I'm struggling to achieve. I have attached the image of the formula I got it working in Excel, how do I replicate using Smartsheet?
CountIfs Dates with ISBLANK Continuation
I am having trouble with my formula. I'm a newbie and my logic be flawed and terrible. Learning in progress. I thought I had received the answer but as it turns out I was still trying to acquire more information. Essentially what I want to do is run the calculation below: =COUNTIFS({Action Plan Week Requested Date},…

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags