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

  • Dates in IFS Statement
    In Formulas and Functions
    I am trying to use dates (formatted in dates columns) in an IFS statement to compare dates in multiple columns and provide calculations based upon whether a date is before or after (<>) a certain date. I am getting an #UNPARSEABLE er…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Andrée Starå
  • Can i populate data referring to multi select drop down(as a primary key)?
    In Formulas and Functions
    i have a column with multi select drop down option, i need to populate the data from another sheet referring to the drop downs select. How can i refer the first column as primary key to populate the rest of the data. My primary key would b…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Umme Salma
  • Find first non-empty cell
    In Formulas and Functions
    Hi, What formula can I use in the Current Email Helper column to accomplish the below Desired Outcome. I'm not using a hierarchy so I cant use CHILDREN()/PARENT() functions. Here's the kind of logic I'm trying to follow: IF [Email]@row is…
    Answered - Pending Review
    36 5
    Answered - Pending Review 36 views 5 comments Most recent by Andrée Starå
  • Dashboard question- Can I add a list of locations to click on and all of the widgets update?
    In Formulas and Functions
    Like in excel pivot tables, how you can add a 'slicer' and then all of the pivot tables you've connected to it- will update their data based on the item you filter/click on.
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå
  • Column formula from a template not allowing me to edit
    In Formulas and Functions
    I downloaded a Smartsheet template and am now listed as the owner, however it is not allowing me to edit a column formula. The column isn't locked, but the formula is somehow.
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Shannon23
  • (Count if) And & Or
    In Formulas and Functions
    I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!
    Accepted
    14 2
    Accepted Answer 14 views 2 comments Most recent by JKremer
  • Help on formula: count if with multiple criteria
    In Formulas and Functions
    Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
    8641 43
    8.6K views 43 comments Most recent by Paul Newcome
  • Nested OR function within and AND logical statement
    In Formulas and Functions
    Hello, I am trying to have the following into a single logic statement: IF Nucleotide Category is "Labeled" AND Characterization Status is "Characterized" AND QC Status is either "Pending" OR "Incomple…
    Accepted
    13 4
    Accepted Answer 13 views 4 comments Most recent by Joseph Adams
  • Formula to automate the symbols on a sheet.
    In Formulas and Functions
    The Task Progress column is linked to the % Complete column.  when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Andrew Stills
  • When move/copying rows, how to prevent new columns being added in the destination sheet.
    In Formulas and Functions
    In Smartsheet's article, it's stated that "If the source sheet contains columns that the destination sheet does not, these columns will be created in the destination sheet when the row is moved or copied." Is there anyway to prev…
    Answered - Pending Review
    27 5
    Answered - Pending Review 27 views 5 comments Most recent by Maram Mohamed