Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
 

Discussion List

  • Announcing Several Formula Enhancements Available Now
    In Formulas and Functions
    Hi Community,  One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faster, but can help you reclaim time throug…
    144 5
    Announcement 144 views 5 comments Most recent by Andrée Starå
  • What formula is needed to count specific catagories from a drop down (multi Select)
    In Formulas and Functions
    Hi! I am hoping that someone has come across this and can offer a little insight on how I can do this. I have a sheet with a drop down column that has multi select. (Image) I want to count each time one of these selections is used and grap…
    Accepted
    12 4
    Accepted Answer 12 views 4 comments Most recent by James P Garcia
  • If this then that...
    In Formulas and Functions
    I am simply trying to create a formula that IF the job code is this, then it auto populates the corresponding Job Title into another cell. Is there a way to do this?
    Unanswered
    3 0
    Question 3 views 0 comments Started by Melody Walker
  • COUNTIFS + FIND Question
    In Formulas and Functions
    Hi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Matt Scroggins
  • Lookup formula instead of value
    In Formulas and Functions
    I am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?
    Unanswered
    4 0
    Question 4 views 0 comments Started by Sean Morford
  • Formulas and functions in forms
    In Formulas and Functions
    Hi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå
  • Formula Woes
    In Formulas and Functions
    My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
    66 11
    66 views 11 comments Most recent by Cat Werbeck
  • Checkbox formula with percentage
    In Formulas and Functions
    Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
    Accepted
    15 10
    Accepted Answer 15 views 10 comments Most recent by David Tutwiler
  • Referencing a sheet
    In Formulas and Functions
    Hi! I'm wondering if there is any way to reference a full sheet. If you are able to do that and then write formulas that include columns within that referenced sheet, will that work? Thanks!
    Answered - Pending Review
    6 2
    Answered - Pending Review 6 views 2 comments Most recent by clairee42221
  • Formula to create a number assignment catalog
    In Formulas and Functions
    Hello, I am trying to create a number assignment catalog that is automated to speak to a smartsheet that has my full collection of products. The goal is when creating a new product anyone could fill out a form select the category numbers t…
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Aaron Olsen
  • Help with nested IF for distinguishing between 4 and 5 digit numbers in a cell
    In Formulas and Functions
    (Image) Hello, We have a formula in this sheet that currently distinguishes between multiple PO#s in the PO column and separates them into individual columns when there's more than 1. In anticipation of using 5 digit POs alongside the stan…
    Unanswered
    14 0
    Question 14 views 0 comments Started by Jay1