Formulas
Discussion List
- 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…
- 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 …
- 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…
- 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…
- 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, e…
- I have created a Dashboard where I’m using the chart widget, the data is being pulled from a sheet (sheet 2), were I pull data from a different sheet using formulas (sheet 1) to be used on the Dashboa…