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

  • Days in progress formula with multiple criteria
    In Formulas and Functions
    Hello, is it possible to run a formula that gets me the following?  If the status is “Not started” or “in progress” then count the number of business days between “date presented” and today, and if the status is “complete” then Count the…
    11 1
    11 views 1 comment Most recent by J. Craig Williams
  • Get Max value with criteria check
    In Formulas and Functions
    I have Table with values as below and now I would like to get max value. How Could i can achieve the Results Required ?. Col1    Col2         A         2580        A         2380 B        1860 B        420 C        860 D        2760…
    187 1
    187 views 1 comment Most recent by J. Craig Williams
  • countif help
    In Formulas and Functions
    Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the…
    1 6
    1 view 6 comments Most recent by J. Craig Williams
  • Sumif Unparseable if to many rows
    In Formulas and Functions
    So I have the following Sumif formula working and giving the proper result. =SUMIF([Business Unit]891:[Business Unit]900, [Business Unit]868, [Implemented FY18 (CUR)]891:[Implemented FY18 (CUR)]900) The problem is the range isn't big eno…
    21 3
    21 views 3 comments Most recent by J. Craig Williams
  • Access (visibility and the option to edit) to SOME rows in a sheet
    In Formulas and Functions
    Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of …
    62 3
    62 views 3 comments Most recent by Tomer
  • Help needed with an If/And formula referencing another sheet
    In Formulas and Functions
    Thank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining column. For some I have tried looking for…
    1 5
    1 view 5 comments Most recent by J. Craig Williams
  • Today(-xx) function in Cross Reference sheet
    In Formulas and Functions
    I am trying to make a Primary sheet for all of my escalation formulas (since i have 14 single sheets to use the TODAY() function).   so...   if(TODAY(-7)> {Date Cleaned}, "enter a name", " ")   so if today's da…
    13 14
    13 views 14 comments Most recent by Elizabeth Aird
  • %Complete with dependencies enabled - Running into limitations :(
    In Formulas and Functions
    Hello all,  Kudos to you all for such an active and friendly forum! I am new to Smartsheet and building an organization-wide task tracker for our accreditation and regulatory compliance for health plans.  I have run into a snag on the bu…
    21 3
    21 views 3 comments Most recent by Shaine Greenwood
  • Calculate days since a bubble turned red
    In Formulas and Functions
    I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days si…
    11 4
    11 views 4 comments Most recent by Daryl Horrocks
  • VLOOKUP Questions
    In Formulas and Functions
    I've got a basic handle on VLOOKUP but what I am trying to do is a little unconventional due to sheet row limitations within smartsheet. We have a sheet in which people will fill in a part number, each part number has a part description. …
    11 5
    11 views 5 comments Most recent by Shawn R