Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • Using "@row" reference with ";" as the separator
    In Formulas and Functions
    Hi the community!   I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";"   When I use the "@row" reference in a form…
    52 1
    52 views 1 comment Most recent by Shaine Greenwood
  • Trying to get fancy with formulas - RYG with "AND" conditions
    In Formulas and Functions
    I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item. I want it to give a Red result …
    11 4
    11 views 4 comments Most recent by Digital_Kru
  • Sigma Level Formula
    In Formulas and Functions
    Good afternoon, Wondering if anybody knows how to enter the following formula that we use in Excel: =NORMSINV(1-(total defects / total opportunities))+1.5 into Smartsheet, we use it to calculate Sigma Levels. Thanks!
    175 1
    175 views 1 comment Most recent by Shaine Greenwood
  • Sum column from form submissions
    In Formulas and Functions
    I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a new record is added at the top …
    205 1
    205 views 1 comment Most recent by Mike Wilday
  • Formula Question
    In Formulas and Functions
    Good Morning. I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly.  Below is the outline of what I am looking to accomplish.  Let me know if …
    11 7
    11 views 7 comments Most recent by Mike Wilday
  • Formulas...CountIfs I believe
    In Formulas and Functions
    In process of creating a formula and I can't seem to get it to work correctly.  Any feedback is welcome. I have two columns.  Both are drop downs.   Column Program:  A, B, C Column Status:  A, B, C, D, E Would like to create a formula …
    41 5
    41 views 5 comments Most recent by clifka
  • Check if a row is parent and starts with "abcde"
    In Formulas and Functions
    Hi, Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
    48 2
    48 views 2 comments Most recent by Meenakshi Sundaram S
  • Help with fuzzy match formula
    In Formulas and Functions
    I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and was hoping to use the approxim…
    137 3
    137 views 3 comments Most recent by Shaine Greenwood
  • Counting Projects that are 1 Week or More Behind Schedule
    In Formulas and Functions
    Hi Everyone, I got a great formula from Customer Success that I thought I would share.  I wanted a way to know if a project was at least 1 week or more behind schedule.  This is what Customer Success gave me: =COUNTIFS(Finish:Finish, TOD…
    14 4
    14 views 4 comments Most recent by Mike Wilday
  • IF statement formula needing help
    In Formulas and Functions
    I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid. I've got the 1st…
    11 2
    11 views 2 comments Most recent by Kelli Lenz