Formulas

Discussion List

  • Is there a way to count the number of CHILDREN in a column?
    In Formulas and Functions
    Hello, I am trying to count the number of CHILDREN I have on a single sheet in my Primary column in order to output the total number of projects we have. My hierarchy in my in my Primary column is "Project Manager" (PARENT) and …
    Accepted
    14 4
    Answered ✓ 14 views 4 comments Most recent by Jay Riel Formulas and Functions
  • How to create an Index Match Formula for multiple sheets?
    In Formulas and Functions
    Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC"…
    Accepted
    14 2
    Answered ✓ 14 views 2 comments Most recent by nlarson_PMC Formulas and Functions
  • Out of Service Formula
    In Formulas and Functions
    Hi Community, I'm attempting to create a formula showing the OOS status of the most recent submission for each asset based on the Asset ID in form submissions. For example, below Asset ID FD-001201 would be considered out of service, howev…
    Accepted
    17 10
    Answered ✓ 17 views 10 comments Most recent by Bryan Letourneau Formulas and Functions
  • Index Match Across Multiple Sheets
    In Formulas and Functions
    Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX(…
    Accepted
    19 3
    Answered ✓ 19 views 3 comments Most recent by MVP OPS Formulas and Functions
  • Formula to change value to a number, then SUM
    In Formulas and Functions
    Hello! I am struggling with this formula & determined I need to start from the beginning. I have created a quiz. It is a mix of multiple choice (A,B,C,D) and True/False (T,F). Each letter will have a number value which is then SUM'd …
    Answered - Pending Review
    15 4
    Answered - Pending Review 15 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?
    In Formulas and Functions
    I have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the pr…
    Accepted
    86 10
    Answered ✓ 86 views 10 comments Most recent by MJ0013 Formulas and Functions
  • COUNT COLLECT
    In Formulas and Functions
    Hi all, I have a COUNT(COLLECT) formula that dosent seem to work. The returned value dosent match the actual number of Red Status projects under the portfolio named "X", also the column status is a symbol and not a word. In the f…
    Answered - Pending Review
    25 7
    Answered - Pending Review 25 views 7 comments Most recent by Tony Oxa Formulas and Functions
  • Formula References vs Lengthy Formula Updates
    In Formulas and Functions
    I maintain a lot of large sheets - at least 9 per FY with around 190 columns and up to 1,500 rows per sheet. Within these are many transit timeline formulas for off-shore shipments. These are often in flux, and when something changes, I n…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Ariana Arden Formulas and Functions
  • COUNTIF Question
    In Formulas and Functions
    Hello We have a sheet that contains variations of words in a multi select column. For example; Lisa, Lisa 1, Lisa 2. I am trying to count how many times the word Lisa appears, regardless of the variation, i.e. Lisa 1 or Lisa 2. I've trie…
    Accepted
    30 6
    Answered ✓ 30 views 6 comments Most recent by Leibel Shuchat Formulas and Functions
  • Conditional Formatting for Cells Containing Formulas
    In Using Smartsheet
    I am working on a project milestone sheet and when projects are first entered the milestone dates are calculated using formulas, based on the start date. As the project gets closer, we will have users manually overriding the formula with t…
    Answered - Pending Review
    19 6
    Answered - Pending Review 19 views 6 comments Most recent by Kelly Pratt Using Smartsheet