Formulas
Discussion List
-
Is there a way to count the number of CHILDREN in a column?In Formulas and FunctionsHello, 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 …
-
How to create an Index Match Formula for multiple sheets?In Formulas and FunctionsHi, 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"…
-
Out of Service FormulaIn Formulas and FunctionsHi 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…
-
Index Match Across Multiple SheetsIn Formulas and FunctionsHi 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(…
-
Formula to change value to a number, then SUMIn Formulas and FunctionsHello! 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 views 4 comments 0 points 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 FunctionsI 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…
-
COUNT COLLECTIn Formulas and FunctionsHi 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 views 7 comments 0 points Most recent by Tony Oxa Formulas and Functions
-
Formula References vs Lengthy Formula UpdatesIn Formulas and FunctionsI 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 views 2 comments 0 points Most recent by Ariana Arden Formulas and Functions
-
COUNTIF QuestionIn Formulas and FunctionsHello 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…
-
Conditional Formatting for Cells Containing FormulasIn Using SmartsheetI 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…