-
What is a formula that will return a cells value located in a table based on two criteria?
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 corresponding value to the pink cell. any help is appreciated
-
Index/Match Returns No Match but vLookUp works?
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 the lookup table is a formula result combining the values of two fields. Seems to work fine when I use the vloopup but not…
-
Formula Date Not Syncing With Conditional Formatting
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 piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel…
-
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 2nd is with children rows expanded on 1 section and a simple fx I am using to copy the TASK NAME parent cell to the TASK…
-
Formula based on text in another column
Hello, I am trying to get this formula to work but it is returning a #UNPARSEABLE error. Any sugguestions?
-
Vlookup formula help
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 one row is the child? I got it to show one of the values (the one from the PARENT row), but I need it to show both amounts in…
-
VLOOKUP Formula?
Hello, I need help with creating a formula that captures two criteria: 1- It assigns a score based on the type of incident. 2- If multiple incidents are logged in a single cell (via a multiple-choice dropdown), the score assigned will correspond to the incident with the lowest weight. For example, if two incidents are…
-
How to calculate certain items for a given fiscal year.
I am trying to count (COUNTIFS) during a given fiscal year. My fiscal year runs from the month of July - June, so currently I am in fiscal year 2024-2025. Column Fiscal Year = Dropdown Column Activity = Text Column Activity Type = Text Column Total = Text with calculation If I change the Fiscal Year the Total column should…
-
Formula not counting correctly
Hi Guys Please note the formula. see pic1 I am trying to count BS Numbers excluding zeros and blanks Pic1 However it's not returning the correct count, for some reason the formula is not counting some of the BS Numbers, see pic 2, the ones i circled in blue (see pic2), for formula is not counting them, i want the formula…
-
Monthly Automation report sends out last months data
I have a simple automation that looks at an employee sheet. On the 1st day of each month at 10am Central a report is sent to my email that SHOULD show the current months work anniversaries. However, every month I receive the email on the first of the month and it shows the PRIOR month anniversaries. Within the sheet I am…