-
Parent/Child Status
Hello, I'm trying to get a setup going in my project templates where the parent cell will update based off the input of of the children cells. For example, the main parent is "Onboarding", with children "Licensing", "Credentialing", "DEA". Then, each of those children has their own children to track individual providers.…
-
Sumifs - Cross Sheet Reference Range Movement
I am working on a calculation where one sheet has month on month cost for a year in columns. i.e. Jan Cost, Feb Cost, Mar Cost etc. in sequential order. In another sheet, I am doing some calculations to prepare the category wise costs based on the first sheet. For each month, all the conditions are same except for the sum…
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…
-
Date Calculation Formula to Return Friday of Week Calculated
I'm looking to return the Friday of the week that my date calculation result falls. For instance, I have a formula that calculates a Start Date by using "Due Date" - 40 WORKDAYS. I need to then have the result show the Friday of that week. My first WORKDAY formula works fine on its own, but not with IF(WEEKDAY...... added.…
-
Using custom value for auto-number in primary field.
I read an old post that said use =[Row ID]1 to copy an automated sequence number in to the field specified. I want more that than just 1,2,3. I would prefer V00001, V00002 etc.. to increment for each new row. Is that possible?
-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
-
Establishing Automatic Due Dates
I have a project that has a launch date of July 2, which is represented in a column. I would like to have a due date be automatically calculated 63 days prior to this date, in another column. I have created a formula that appears to work, in principle, but rather than setting the date 66 days prior to the July 2 (April…
-
Formula help: log a date in sheet 1 when all tasks assigned to me in sheet 2 reach a certain status
I am wanting to create a formula for the below scenarios, but am not sure how I would go about it or if it is feasible - For each new job, we create a sheet to log POs and subcontracts needed, and a second sheet to track project deliverables. One deliverable is to have all the POs/Subs complete, a second deliverable to…
-
Why is my VLOOKUP returning erroneous data?
I am using a cross-sheet VLOOKUP formula on several rows in a master sheet. It is working correctly in one column, but for the other column the formula is returning erroneous data for only a few rows. For instance, in a couple of cases it is finding a search value that does not exist in the referenced sheet, then returning…
-
Join Function Not Working As Expected
When I join across cells it is taking the last option from the Core Column and the first option in the Calyx Column and combining the text. Any suggestions will be helpful. The formula I am using is =JOIN(Core1:Calyx1, " ")