-
Restricting dropdown lists using VLOOKUP
Depending on values in one column I want to restrict the dropdown list in another column Example: I have a sheet: Employees Role Name ------ ------------- PM Jane PM John Dev Mark Dev Stephanie In another sheet where Tasks I have these same two columns Role and Name Once I enter the Role (say PM) it should automatically…
-
Rule (Formula) to Check a box if the create date is past 90 days
Thanks for checking this out as my formula game is pretty weak. I am looking to have a formula that will check a box if the create date is 90 days in the past provided another box was checked.Real world I want to call out all statements of work that are older than 90 and we have not received a purchase order (PO received…
-
Sum Children If other cells are Checked
Hello Community, I'm trying to get a sum of children cells if a checkbox in another column is checked. For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.
-
count cells with the same date that are NOTBLANK
Hi, I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date. Sheet1 has several ROWS with the same dates. Sheet2 has only one date per ROW. I would like to COUNT Sheet1 rows that have equal Dates and insert it in every row in…
-
Sumifs and Children
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children values if they meet the three conditions . Specifically, I use a cell value from the main sheet to find the referenced parent row…
-
Formula for RYG using % Complete and Finish Date
I am trying to populate my Status field, using RYG formatting (based off the % Complete and Finish Date). I am trying to use an AND/OR and it is not working for me. I can get half way there, but not completely. My Status Definitions: Gray - Not Started Yellow - In Progress Green - Completed Red - At Risk I would like to…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
