-
Single-Select drop down menu autofilling options
Hi, I am attempting to select an option from a single-select drop-down that will auto-fill the next column. I have loaded the formula as a one to one basis, i.e. if 'this person' is selected, populate 'this manager' in the next column. However, I need it to be across multiple employees. So if, this person, this person, or…
-
HELP writing a multi-variable IF Formula
Looking for some help with automating a Health column with Red, Yellow, Gray, Green balls based on 4 corresponding values in a Status drop-down. But there are also some overrides that I want to incorporate and can't figure out. Back Log = Gray In Progress = Yellow Flagged = Red Complete = Yellow Override 1 Marking…
-
Problem with nested IF statements
I'm having a problem with the following statement. Each IF statement works independently, but not when nested. Can't figure out what's wrong. =IF(AND(Budget1 >= 100000, [Executive Sponsor approval2]1 = "Approved", [Finance Approver approval]1 = "Approved"), "Yes", =IF(AND(Budget1 < 100000, [Executive Sponsor approval]1 =…
-
IF formula with allowable variance
I need to write a formula that will put Yes in the column if the Quote and Invoice values are within $5 of each other, or if the Quote Frequency is recurring. Here is what I have so far, but I can't figure out how to add the allowable variance of $5 =IF(OR([Quote Amount]13 = [Invoice Amount]13, [Quote Frequency]13 =…
-
Formula Help
I'm trying to calculate how many days the process takes. I want to calculate the days from "Date Request Received (LAW)" to "Date of City Council Decision". If "Date of City Council Decision" is blank, I'd like it to use today's date. I can't figure out where I went wrong. Thanks in advance! =IF(ISBLANK([Date of City…
-
Date formulas - Months
Hi - I'm trying to add 6 months to the day to a date referenced in another field. It is basically a date of execution and plus 6 months a review date. How is this possible? Adding the number of days gets me close, but not exact. Thanks!
-
COUNTIFs for Dates
I'd like to create a formula which only counts the Rows in which a date in a particular column is in the last 30 days (among other criteria) =COUNTIFS({Referral Source}, "Elm", {Database Status}, "Green", {Database Date of Referral}, <TODAY(-30)) The section in Italics is the area I am trying to sort out. Thanks in advance…
-
Adding column of summary date values
I have a "Date Completed" column in my list that I would like to roll up like Start and Due Date do with sub-tasks in the hierarchy. I have been unable to figure it out with formulas. So, I am looking for the last date entered in "Date Completed" of a sub-task to auto fill that same date into the highest level of the task.
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
COUNTIFS Using multiple ranges and OR statements
Im looking to count the number of times specific ranges happen from 2 separate columns. Essentially, I want to count number of issues open by Priority, excluding 3 different status types. Current formula only excluding "Resolved" =COUNTIFS({Priority}, "1 - Critical", {Status}, <>"Resolved") Need formula to exclude multiple…