-
Need your advise on Nested if
Hi All: Need your advice on the following problem. I have three columns [RUN/INVEST], [MUPOR] and [CHECK] in my sheet. I also have two separate data sheets SHEET1 and SHEET2. And I want to write an if else formula as below for [CHECK] column values if ([RUN/INVEST]1 = "Invest") then {Look for [MUPOR]1 value in column1 of…
-
countif column values based on a monthly value
Hi, I am creating a table of count of values in a column based on what month is reported in another. the table I want is attached. The formula I am using is as below. Can anyone advise what need to change in the planned formula =SUMIF{V2.0 Eirabot - Gantt Range 1}},"12", {V2.0 Eirabot - Gantt Range 1} I also want to have…
-
email lookup
hi, Is there a way that if I choose a name from a drop down box in one column it will show the appropriate email address in another column? regards, Mark
-
Checkbox Range Formula
Hello- Is there a formula that will check a box if another range of cells is also all checked? For example, I have a column that has 5 checkboxes in it. I want another cell to also check off as soon as all 5 checkboxes in the column have been checked.
-
Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…
-
Nested IF/AND Help with RYGB Status Balls
I'm trying to accomplish two things: First, for the "Status Visual" column, I'm trying to state the following formula: * If the "Task Finish" is 3 days overdue, and the "Task Status" is not "Complete" the ball should be red. * If the "Task Finish" is 1 day overdue, and the "Task Status" is not "Complete" the ball should be…
-
Searching a series of columns for blanks
Hey all. I am trying to have a column search a series of columns and return the data from the column that is not blank. I have started with the following: =IF(NOT(ISBLANK([Title:]1)), [Title:]1, [Peer to Peer Program Title]1) Which checks the Title column, and if not blank returns the data from Title: column. If the Title:…
-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
Pulling data from one sheet to another
Hello: In Sheet 1, I have Column A that lists courses to be developed in the next term. There are several rows, but not every row contains a course. Row 1---BUS 123 Row 2---CUL 232 Row 3--- Row 4---DSH 343 Row 5---ENT 111 Row 6--- Row 7--- Row 8---HSM 399 In Sheet 2, I would like to include the list of courses from Sheet 1…
-
Formula for selecting checkbox will populate completion date
Hello, I've looked through different discussions to see if I can figure this out. I'm trying to find a formula that will populate a cell with the date of when the checkbox in another cell has been selected. In other words, when I check this box that I have completed this item then I want another cell to populate the date…