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.

INDEX MATCH MAX Pulling Randomly
I am pulling out my hair with this formula, I have used it in this sheet in a similar fashion and in othe sheets as well but for some reason I am only getting random values returned. In the LVC.Helper Column: =IF(COUNTIF([MLL ID]:[MLL ID], [MLL ID]@row) > 1, INDEX([Label Version Code]:[Label Version Code],…
Stumped- Possible VLOOKUP Formula?
Hello :) I am trying to add a checkmark next to anyone's name who has served as a reviewer when their name appears in the provider being reviewed column. All this info is in the same sheet. Any ideas on a formula?
Copying multiple values from one column to a new sheet
Hi all, We are using Smartsheet to forecast staff LOEs across projects. We currently have a Data Input sheet where staff LOEs are entered by project (nested by Center). We then have another sheet, Enterprise Rollup, which searches for staff names and adds up their LOEs across projects to calculate their forecasted direct…
how to get commas between join/collect of multiple sheets
I have a formula.. a very long one 😂 that is pulling numbers from multiple sheets however it is only putting comma/spaces between numbers from the same sheet. Numbers from different sheets are just mashed together. Is there a way to fix this? =JOIN(COLLECT({Deviation Tracking Log- QMS Number}, {Deviation Tracking Log-…
Formula for Category/subcategory lookup in Smartsheet Forms
I have a form running with Categories and then i used logic to create subcategories. Is there a formula that I can create to pull information from the form based on the category that is chosen? For example: Services Category: A, B, C or D A Subcategory : 1 , 2, 3, 4 B Subcategory: 5,6,7,8 Basically if someone selects A it…
INDEX Match throwing incorrect answers
I am trying to use a unique identifier by column, to reference another table that has that unique identifier in it and provide it's adjacent value from another column, by row. This is the formula I'm using and it's giving me values in that list but the wrong value: =INDEX({Hours}, MATCH([Combined Work Description]@row,…
countifs formula
I am trying to find the formula to count if something is found in one column and somethings else is NOT found in another column
How do I create a fraction to represent the amount done
I am trying to create a fraction to show the #closed items vs the number of total items. I have already counted them so for example in column 1 it says 5 and in column 2 it says 25. I want to see in the next column a fraction that represents it so in this example it would say 5/25.
Extract a MM/DD/YY Date from M/D/YYYY HH:MM
I'm looking for some formula help to convert a date format. The date column I'm referencing is coming in from another source, and is formatted as M/D/YYYY HH:MM - here's some example data from the sheet: I need to compare these dates to a user-set date (column = Prior Run Date) in my sheet, which is a Date column type…
Vlookup add days to dates considering no weekends/holidays
Hi! I have a column that a user has entered a date something was submitted (Date Submitted to Courseware). Based on the priority selected (1-4), it will add a certain number of days to the Date Submitted to Courseware to tell me when it is due not counting weekends or holidays. Formula: =IFERROR(WORKDAY([Date Submitted to…

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

Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
Issue with Highlighting Columns that have different values
I have a sheet where I am tracking values from one month to the next (values imported using DataShuttle). I want to highlight the columns where the values are different, using a helper column: =IF(Bananas@row = [Previous Bananas]@row, 1, 0) However, I am having the formulas return 0s when the formulas are NOT DIFFERENT.…
Net Days between a previous day and today.
I have the following columns Comments Date of Last Attendance Weeks Not Submitted Under "Comments", you might see something like "Last Attendance Day: 11/01/2024." I used =RIGHT(Comments@row, 10) to get the Date of Last Attendance. I need to determine how many days it has been since that date using today's date, and divide…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags