-
Mean Time Between Two Dates from Form Submission
Hi Community, I'm attempting to find the average downtime of an asset between dates from a form submission for the month. For example below, I need to find the number of days between the "OOS Tag Removal Date" and "Date OOS Tag Applied", based only on all entries for "Asset ID" FD-001201 where the "Reason for OOS" is…
-
Help: Formula Creation Request Please
Can someone help me by typing out what I hope is a simple formula? End result, when I update my "Status" column, I want it to enter the following amounts in my "% complete" column. FYI, Status is a drop down single choice column type. I will be so appreciative! I just don't time to figure it out by trial & error. Example…
-
#Invalid Operation error with simple Index formula.
I am getting an #Invalid Operation error with a really simple index formula. =INDEX(Contract:Contract, 2) This formula is in a Sheet Summary field. The summary field is text/number and the column referenced is a text/number column with a column formula that produces numbers. The column has the Currency formatting on, but I…
-
Can I create a Column Formula which automatically applies text in a Parent Row to the Child Rows?
When rows move into my sheet, I use them as parent rows for my projects. I want to have a column formula which automatically pulls in data from the parent row to its child rows. I've tried putting =PARENT() into a child row but it makes all cells in that column empty when I convert it to a Column Formula. Any assistance…
-
Calculating Days Remaining and Past Due
Hello everyone, I am trying to calculate the days remaining and days past due for each row, however, I want it to stop count if the status is closed. As you can see we have a "Days Remaining/Days Past Due" column and those closed (the grayed out rows) still calculate a number which is what I do not want. I tried doing it…
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Solving for data issue when exporting data from external source.
I am trying to create a helper column that will help a colleague manage data that he needs to export from our inventory management system to evaluate in a team meeting. The issue is that he has currently been manually fixing a common data error where, occasionally, the name of an item is exported incorrectly. It always…
-
Is there a formula to indicate the change in status direction if updated in a given time?
I want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an upward arrow; if status went from Green to Yellow, Yellow to Red, or Green to Red in…
-
How to find the lowest value number in a gap from a sequence of numbers?
Hello! I am currently working on a sheet that will allow us to assign a numbered item to a teammate and keep track of who has what numbered item for traceability purposes. The audit process has been completed and fully automated but I wish to make this more automated during the assignment process. Currently, we manually…
