-
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
-
IF Formula Looking at Multiple Columns of Check Boxes
I have the formula figured out if only needing to rely on "looking" at one column: =IF([Approved?]@row = 0, "Pending", "Closed") I want to update the Status column to also take into consideration the "Approved as GRA Extension?" column. How can I write the formula so that if a box is checked in EITHER the "Approved?" or…
-
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
-
IF::Then reference separate sheet
Hello I have (2) sheets I am working on. One is my Main_Running project sheet. The 2nd, I would like to populate depending on whether a column in the Main is "starred" If Column_is_starred; then I want it to pull in information from a separate Main_sheet column. I would like the 2nd sheet to only be populated if/when the…
-
INDEX(COLLECT - #Invalid Value Error
Good afternoon everyone! Looking for some help with INDEX(Collect. I have a main sheet set up and also have created a helper sheet. Once the install date on the main sheet is changed, automation copies that row to the helper sheet. I want to see on my main sheet the previous install date as well. This I've figured out. I…
-
Help with multiple IF ISBLANK statements
Hi, I am trying to list values, comma delimited, from a number of columns based on if the previous column is blank. So for example, based on this table: Object Code 1a Object Code 1b Object Code 1c Object Code 1d Object Code 2a Object Code 2b Object Code 2c Object Code 2d Object Code 3a Object Code 3b Object Code 3c Object…
-
Help with IF + MAX formula with OR
Hi, I'd like to make a formula for the following purpose: We have daily quotas that need to be reached, however it changes depending on the day. Monday through Thursday the goal is 3, and Friday the goal is 1. I'd like an IF formula to do a MAX operation depending on the day. This is so that every day we can see how many…
-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
IF Formula
Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10" Formula i used below but not working =IF([Time Criticality]@row <= 30, "10", IF([Time…