Formulas
Discussion List
- Hi there, I am trying to index match on data in the second level children rows from Sheet 1 to second level children rows on Sheet 2, and am getting this error messages. Screenshots are at the end. Sc…
- I'm trying to find the average lead time for completed projects that were started this year and I'm having an awful time. Full disclosure, I'm not great a writing formulas. I can get the average lead …
- I have this indexed @row info to a column named "AR" (Format will always be like this and no middle name). I need to split First two words to column named "Name", Split email to column named "Email" a…
- I have two columns, Column A and Column B. How can I check Column A for a condition, and then count all the distinct corresponding values in Column B for which that condition is met? Is there an easy …
- So i want to include an interactive element on my dashboard when my client will chose the borrow amount and the term from two dropdowns. Ideally this would lookup the table on the right and return the…
- I have an index/match formula that is returning a No Match and when I try the Vlookup it is working. =INDEX({BE Job Intake Range 1}, MATCH([Project ID]@row, {BE Job Intake Range 2}), 0) The colunm in …
- Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual pi…
fx to auto pop TASK CATEGORY, single select drop down, based on parent row TASK NAME, primary column
I am trying to use card view reporting and sheet function sorted by TASK CATEGORY single select drop-down column. Below are 2 screen grabs, 1 is TASK NAME, primary column, children rows collapsed. The…
- Hello, I am trying to get this formula to work but it is returning a #UNPARSEABLE error. Any sugguestions?
- Hello - I created a summary sheet using the vlookup formula referencing another sheet. However, how do I show two amounts from two different rows in the source sheet where one row is the parent and on…