-
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, " ")
-
A Single Formula to SUM a variable range of cells in a row
Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum the first 19 cells. The range is always contiguous, and the cells to be summed always…
-
How to capture a value from multi-select column
Which formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection values and adding them in a separate sheet (so using cross sheet reference). Have…
-
Formula to add 1
I am trying to figure out a formula that will add 1 to the Parent [DMR #] The below will Place a "1" at the end but I need to add count by one Like this DMR5575-1 DMR5575-2 DMR5575-3 =IF(Level1 = 0, [DMR #]1, PARENT([DMR #]1) + "-" + 1)