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

  • COUNTIF of CHILDREN with HAS
    In Formulas and Functions
    I'm running into an issue with a formula that I'm trying to write that counts the results of a multi-dropdown column using the CHILDREN hierarchy. =COUNTIF(CHILDREN([Event Tier]165), HAS(@cell, "Tier 1: Off-Site Event")) I'm lo…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå
  • End User decision making on which smartsheet to update
    In Formulas and Functions
    Hello, I am relatively new to Smartsheet but finding the functionality robust. I am looking for a way to create a workflow that will direct end users to the appropriate Smartsheet Example: Are you requesting an update at the Doctor leve…
    Accepted
    6 3
    Accepted Answer 6 views 3 comments Most recent by Andrée Starå
  • Is there a formula for checking a box if date in another column is changed?
    In Formulas and Functions
    I have a checkbox column that I've set up a "Change Cell Value" automation to check the box when the date in another column (Due Date column) is changed. However, I would like the box to be checked only if the change in date is g…
    Answered - Pending Review
    5 1
    Answered - Pending Review 5 views 1 comment Most recent by Andrée Starå
  • Forms that need to incorporate multiple line entries
    In Formulas and Functions
    We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
    513 23
    513 views 23 comments Most recent by Filip Teugels
  • Formula to find latest/most current
    In Formulas and Functions
    Hey friends!  I have two sheets. I need one to behave as a "log" (columns: Machine SN (Primary), Machine Hours, Machine Status (Dropdown List), Current Machine Location). This log will be populated by Forms. The second, separate…
    Unanswered
    7 0
    Question 7 views 0 comments Started by Mike Meyer
  • Formula to only show characters before a specific character in a cell?
    In Formulas and Functions
    Hey friends, Needing some help creating a helper column. In column from imported report I get, "Asphalt Distributor (45)" where the "45" represents the quantity of assets in that category. I need to create a helper c…
    Answered - Pending Review
    7 2
    Answered - Pending Review 7 views 2 comments Most recent by Lidiya S.
  • Adding # of days with in a date range
    In Formulas and Functions
    this is what i came up with looking at other people i keep getting #invalid operation =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Util…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Kyle Black
  • Gantt View Settings Start Date Column Selection
    In Formulas and Functions
    While in the settings for my Gantt View my "Start Date Column" drop down selections does not include the column I want to use. It was there before. What could have happened. It is formatted as a Date. Also baselines keeps bein…
    Unanswered
    5 0
    Question 5 views 0 comments Started by dgloballab
  • Highlighting duplicate data based on two conditions
    In Formulas and Functions
    Hi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country…
    801 42
    801 views 42 comments Most recent by LisaB:-)
  • Alphanumeric number parse to just the alpha
    In Formulas and Functions
    I have a column with an alphanumeric number "CYG2525" or it could be "C2525", "GY2525". As you can see the alpha can range in the amount. I need to be able to pull over just the letters so "CYG" o…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by dgloballab