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

  • Two new PPM Functions: Successors and isCritical, available now!
    In Formulas and Functions
    Hi Community,  We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical.  The Successors function (type: numeric) allows users to calculate the direct successors of a task…
    56 0
    Announcement 56 views 0 comments Started by Morgan Kozol
  • Date format
    In Formulas and Functions
    Hi, Could you make it possible to edit the date format as you can in excel or add this date format DD.MM.YYYY?
    Unanswered
    3 0
    Question 3 views 0 comments Started by Trond
  • Drop down list from another sheet
    In Formulas and Functions
    I currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to …
    Accepted
    2571 10
    Accepted Answer 2.6K views 10 comments Most recent by Jeff Hayford
  • COUNT with Distinct with multiple criteria
    In Formulas and Functions
    I am trying to create a count when 2 different criteria, when combined, are unique. Here is some sample data: I am trying to count late bills (checkbox) only when the customer number and bill date combined are unique In a summary field, I …
    Unanswered
    6 0
    Question 6 views 0 comments Started by AFlint
  • Formula to show the number of items that meet 2 criteria
    In Formulas and Functions
    I am looking to tally up the number of tasks that meet the following criteria: Don't have a check in the column "Done" Have a due date within the next 14 days I am actually going to create 3 buckets (due within the next 14 days f…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Iastate7653
  • It there a formula to use so that I can calculate an amount between dates?
    In Formulas and Functions
    Hi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
    Unanswered
    4 0
    Question 4 views 0 comments Started by Justine
  • Status If/And Formulas
    In Formulas and Functions
    I have a project manage sheet I'm managing that I can't seem to get the formulas right in. The first one has two parts. 1) I want the status to be green if the Planned Completion Date is equal to today or the future. The Status to be Yel…
    Unanswered
    4 0
    Question 4 views 0 comments Started by Emily T.
  • Formula for Max Value and Row Name
    In Formulas and Functions
    Hello - I am trying to pull in the max value of column A and the name(s) associated with that value. I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value…
    Accepted
    14 2
    Accepted Answer 14 views 2 comments Most recent by Justin Tackitt
  • countifs from a multi-select to count two items
    In Formulas and Functions
    I have a multi-select field with 3 items (ex: A, B, C). I want to be able to get a count for 1) cells with A and B and 2) cells with all (a, b, c). Running into trouble. I've tried: =COUNTIFS({acct type}, "Signed Account", {Pro…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Devin Lee
  • What is wrong with my formula?!?
    In Formulas and Functions
    Hi all I am using the following formula to tell me if a certain selection is made and another entry is greater than or equal to 12, but for some reason it is still flagging as Yes even when the cell is less than 12. What am I doing wrong?…
    Accepted
    17 2
    Accepted Answer 17 views 2 comments Most recent by brianw
  • Combining IF statements
    In Formulas and Functions
    Hi Smartsheet community, I am currently trying to create a formula, that states if Updated Completed Date is blank then use the date in Original Completion Date column but if not blank then use the date in the Updated Completed Date column…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Angelique1