-
How do I generate the same information that is entered in the parent, into the children?
I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is the deciding status, the status that matters. I want to show all projects that have a certain PM assigned, AND if the…
-
Formula @Row Question
I am trying to edit a formula for our naming convention column in SS. The below is our current formula. At the end it pulls in the year according to today's date. Instead we want to remove that and have it pull in a date (just the year) from our "Final Due Date" column. How would I edit the formula to pull that in? We…
-
Minimum Date in a range of dates that is >= Today?
I need a formula that returns the minimum date from a range of dates that is greater than or equal to today's date. I use the MIN function to return the minimum date in the range but, I need the minimum date that is greater than or equal to today's date. Today's date needs to be automatically generated so I have been using…
-
Flash-fill a column similar to Ctrl+E function in excel
I am looking for a solution similar to the Ctrl+E flash-fill feature in Excel, or a formula to extract just what I need into another column for export. For example, I need a column that has information set up like "101 - Class Listing" to have a column lined up next to it that has the "101" extracted (all in the same row).
-
COUNTIFS using different sheet for range and month for criteria
I am attempting to get this formula in my tracker sheet to work to count all the instances in the reference sheet where a certain month in the date column occurs and the answer to a question in another column is no. This is the formula I have come up with and I know it's wrong but all of the fixes I have attempted have not…
-
automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made…
-
Auto filling a cell based on the entry in another cell
Hi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form just on my sheet when the entry has been submitted. Sorry i am really struggling with this and fear it is around Vlook up…
-
index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
-
Formula to check the Unit availability
I would like to check the Unit availability, we want to check the start date & end date and U1, U2, U3, etc. and unit availability column should provide whether it's available/nonavailable to use for other projects Is there any formula that can do this? Also when a unit is assigned for a particular project for a particular…
-
Quick question about creating an IFERROR statement after an OR statement
Hey everyone, Hopefully this is an easy question, though I'm having a hard time figuring this out! I'm trying to write a COUNTIFS statement that can be broken down into quarterly segments. I learned that an OR statement would allow me to include multiple months in the statement, but now I don't know how to properly include…