-
IF/OR Quarters Formula
Hello! I am trying to come up with a formula to assign Quarters to a sheet, based on if the month is 1, 2, 3, etc. (Jan, Feb, Mar, etc.) I am trying to use IF(OR and I get it to work until Q2, but for some reason when I add Q3 section (highlighted) it is saying syntax is wrong. It is probably something obvious that I am…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Is there a way to calculate the change of role in percentage?
Hi, I have a tracker, whenever the role/status change, it'll copy to this sheet. I'm trying to find a formula to calculate the change % from coordinator to admin, and from admin to the coordinator. Is there a way to do so? TIA!
-
Nested If Statement Not Working
I am trying to write a nested IF statement to automate the RYG status balls in a status column. It will not work, it always say they are red. What am I doing wrong? Logic Needed: If less than 70% complete, "Red" status ball If 70% or above and less than 100% complete, "Yellow" status ball If 100% complete, "Green" status…
-
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…