-
Parent Marked Qualified and changes status of all Children relation
If Status on the parent is marked qualified it will fill all the tasks below for this section only qualified. Which will stop all the alerts. How do I make it so it only affects this drop down and now all the ones on the sheet. And have this same situation going for all the dropdown
-
Counting Item that meets Criteria.
Good Evening Community. Trying to count an item that meets certain criteria. For example I am referencing two columns of the same sheet and trying to count the first column that contains Food POS and has a Projected Status of Projected Install. Below is code that has been attempted. =COUNTIF(AND(({POS Install Status},…
-
Formula Needed to Check Time From Created Date and Put Into 2 Statuses
Hi All, Trying to work with Created Date column to extract the time from Time Stamp, then look at the time to determine if it falls within two statuses. This is for a Rush Payment Cutoff Time. If an entry is submitted in our sheet before 1pm that day, I want the column to say "Same Day" and if after 1pm, have it say "Next…
-
Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
-
Automatically adding new row data to formula
I have a few formulas on the top 3 rows of my sheet that are KPIs for the sheet. Since they consume the top few rows, I cannot select the entire column in the formula or it returns an error of Circular or Blocked. So I need to start the range with (ColumnHeading4:ColumnHeading99) and I cannot figure out how to always…
-
RAID Risk Matrix
Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.
-
Unix/Epoch Timestamp to DATETIME format?
I'm trying to convert a Epoch Timestamp into a DATETIME format. I've had success using formulas getting it into a date, but am unable to get the time. Anyone have any insight on how to accomplish this? 1517577336206 as a timestamp example which I'd like to convert to 2/2/2018 8:15:36
-
Cell Changed Color When Formula Updated
I just updated a date cell formula to give someone a little longer to complete a list of tasks and they all turned yellow. It' not a cell filled color because you can't remove it. I have updated this formula before and not had any issues with the box changing colors, so I can't figure out why it's doing it now. It's a…
-
Compare Contact Column vs Email contact Column
I am using the proof info columns, and sadly they only return the contact email. I want to compare this to a "Reviewer #1" contact column to see if everyone in the Reviewer #1 column has approved, I tried the following formula: =IF(CONTAINS([Reviewer #1]@row, [Approved By]@row), 1, 0) and it did not work. Any thoughts?…
-
Using Match to look for multiple strings and how to evaluate a #NO MATCH
Ok, I am trying to find a way to use Match to look for two values in a column and return the first one found. I know you cannot look for multiple strings in the same formula (at least I haven't been able to write one), so I created two helper columns. The first helper column looks for string A and the second helper column…
