-
Formula to return non-blank value from multiple cells
I have a number of columns in a row and only one of them will be not blank at any one time. I'd like to program another cell that will "look" at these cells and return only the value of the cell among those columns that is not blank. Is this possible?
-
Formula Help - Not sure what I am missing here
I'm working with a formula that should indicate the stage of an employee's onboarding based on a table. The stages are labeled as "PHASE COMPLETE," "PHASE NOT STARTED," and "PHASE IN PROCESS." However, I'm encountering a few issues: When everything is marked as complete, it returns an "invalid formula" error. If no phases…
-
Calculating Dwell time
I am trying to get the dwell tome to show in my sheet by using the formula below, but it wont bring back a value for me in days only showing '0', I have applied the formula to the whole column 'Dwell time' what could I be doing wrong please ?
-
Pulling Partial Rows Using Index/Match
Hi all, I'm hoping someone can point me in the right direction here. I'm trying to figure out the best way to pull partial rows from one sheet to another without using Bridge. Specifically, I'm trying to pull requests that were populated on a separate grid sheet through a form over to the department-wide tracker grid…
-
Cross Link without Locking Cells
Hello, I have a main tracker (T1) and a sub-tracker used for only one team with limited view (T2). I need to link the tracking cells so someone can enter data on both sheets and it show up on T1. However, on T1 I have additional lines in the same column that require updating but will be locked if I try to run a column…
-
How to get a formula to count only negatives or only positives
I have two formulas for a helper column to a metrics sheet. I made a column that counts the number of days until an order is due to arrive, and then there are two helper columns. the first needs to take those numbers and return a value based on the number. So if the order is set to arrive in 5 days, then the value would be…
-
Creating an intake form for a task sheet which has tasks and sub tasks
My team's tasks sheet has a lot of columns, other than the usual Task name, start date, end date, status etc. To make the task entry easier, I am trying to create an intake sheet. However, the sheet has both tasks and sub tasks, which make creating the form little challenging for me. I am able to enter the tasks one by one…
-
COUNTIF multidrop down values
I am trying to create a summary sheet to give me the number of values in a multi drop down list. I need the exact match. I used this formula, but it's coming back #unparseable. =COUNTIF([KSK Middle/High Testing Dates]:[KSK Middle/High Testing Dates], HAS(@cell, "October 7, 2024))
-
Help with multiple condition
I am looking for the right formula so that changing the Month does not affect the count of the previous month. =COUNTIFS({Asset Health Tracker Range 2}, "Lawn", {Asset Health Tracker Range 3}, "August", {Asset Health Tracker Range 1}, "Red")
-
How can I get a multi-select dropdown column to populate with comma separation?
I have a two different columns that are populating differently, just using simple formulae: (I took out all the error checking to make it simple until I can get it to work) =[Name]@row, where [Name] is a Contact list, allowing multiple contacts per cell, and =[Department]@row, where [Department] is a Dropdown list, also…
