Discussion List

  • Formula to count cells in a column if box is checked
    In Formulas and Functions
    I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.   In other words, there are two columns to include in the count from my Comm…
    464 1
    464 views 1 comment Most recent by Morgan Marquez Formulas and Functions
  • Drop-down list
    In Using Smartsheet
    I have a drop-down list of names on my sheet. I need to remove one of the names and add a new name, but I want to keep the list in alphabetical order. I can't find a way to re-order the names in the dialog box where I add the new name.  Do…
    307 7
    307 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Count a Titled Course if there is text in the cell, but not "OTHER"
    In Using Smartsheet
    Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly.  On rare occasions, a course is not taught and OTHER is entered in that column. (OTHER could mean initial meeti…
    31 10
    31 views 10 comments Most recent by Andrée Starå Using Smartsheet
  • I need the sum of random cells in a row
    In Using Smartsheet
    Here is my formula, and S/S does not like it.   = [National Instructor 1 Numerator]@row + [National Instructor 2 Numerator]@row + [National Instructor 3 Numerator]@row + [National Instructor 4 Numerator]@row Am I missing something?  I c…
    22 13
    22 views 13 comments Most recent by Paul Newcome Using Smartsheet
  • Graphing Data
    In Formulas and Functions
    Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario:  Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …
    75 0
    75 views 0 comments Started by cthrasher97141 Formulas and Functions
  • Tick a checkbox depending on value of another field
    In Formulas and Functions
    I have a multi column Smartsheet that tracks items by date.  Part of the functionality shows the number of days the item has been active:-  =IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5) There is also a check box col…
    175 1
    175 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Added information needed on Approval workflow
    In Using Smartsheet
    I have many forms - which are requests that need approval.  When I create the approval workflow, it sends 2 buttons - Approve or Decline.  I need more.  I need a NOTES section for when it is denied so that the reason can be recorded on my …
    106 7
    106 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Help with IF(AND) formulas
    In Using Smartsheet
    = IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1.  Otherwise, 0. What I've written above is what I want to do.  Below is the formula, which gives me the …
    21 8
    21 views 8 comments Most recent by Kitty Using Smartsheet
  • Hide Email Address on Webform using Contact List
    In Using Smartsheet
    I am trying to find a way on the Smartsheet web form to display the Name from the contact list, but not the email address. This is a public form, and while I want to be able to alert the event coordinator that something has been submitted,…
    96 3
    96 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Is There Really No Built-in Log\NL Function?
    In Archived 2017 Posts
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    275 2
    Closed 275 views 2 comments Most recent by Ford Archived 2017 Posts