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.

COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being referenced from the same sheet where: {product} = Product1, Product2 {status} = Done, Ready for…
Date formulas
I am very new to this and don't work with formulas often. I am trying to create a formula that will update the finish date automatically based on a given timeframe. For example start date is 10/12 next column gives time expected to complete task 6 weeks. I want to create a formula that will autofill the completion date in…
Formula for Health column
I would like the color of the circle in the Health column (formatted from a drop down list of RYGB balls) to change based on the status selected in the previous column containing a drop down list of "Not started", "In Progress", "Behind" and "Completed". Is this possible?
Multiple index/match nested in an If statement
Hello, I am having some issues with the following formula not returning the value I am expecting: =IF(CONTAINS([Raw Lot ID]@row, {ActiveRawLot}), (INDEX({ActiveQCResult}, MATCH([Raw Lot ID]@row, {ActiveRawLot}))), IF(CONTAINS([Raw Lot ID]@row, {ArchivedRawlot}), (INDEX({ArchivedQCResult}, MATCH([Raw Lot ID]@row,…
Exact age to the year, month and day as of today's date.
Hi I am in the process of switching to Smartsheet and I have a formula in excel the provides me with a child's age exactly to the year, month and day as of todays date. I have been trying to find a formula that works in Smartsheet to provide me with the same data. Every formula I have found has rounded the age to the year.…
Is it possible to link smatsheet to an external spreadsheet?
Is it possible to link smatsheet to an external spreadsheet?
Counting values
I have over 30 sheets which I store the portfolio the belong to in a sheet summary field (a drop down). I am needing a way to count these values. I am wanting to count how many schedules have the value "ETG Project Portfolio 2020" in the Portfolio summary field. thanks in advance for the help.
Making automatic links between sheets
Hi there, here is the workflow: User enters data into a form (done). Form populates a sheet called Master_sheet (done). One of the entries of the form is a dropdown, lefts say for example: Dog, Fish and Cat There is an sheet called Dog. If the person who completes the form chooses the Dog option, the some new entries in…
Contact group row notifications
Is it possible to email a contact group when updates are made to a specific row? Michael
Health Color Bubbles Tied to % Completion & Dates
Hellow, I am trying to take the following plan with the follow formula to follow these rules and am stuck. Disclaiming not the best at the large multi conditional formulas yet. I use the Health Column bubbles RYGB If a task has 0 % Complete and is not past Start Date, green or no health ball if possible If a task has > 0 -…

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

Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags