-
Holding A Column Position in VLOOKUP Formula
Issue = Within my VLOOKUP formula =VLOOKUP([Example]1, {Test}, 16) the column position is 16. If at some point a column is inserted to the left of column 16 in sheet {Test} then my VLOOKUP formula returns incorrect data! Question = Is it possible to get my VLOOKUP formula to hold to the column itself rather than its number…
-
Dual parameter formula to capture last entered date versus last date of column?
Currently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into individual columns. Using a MAX/COLLECT reference formula I am able to retrieve the last…
-
Compare dates in the same row but different columns
Hi all, Im looking at counting the number of times two date columns differ within the same row For example Column 1 Column 2 11/2/20 11/2/20 11/4/20 14/11/20 11/3/20 11/3/20 25/5/20 12/6/20 In this data the answer i am looking for is 2 as row 2 and 4 both differ, whereas in row 1 and 3 the dates are the same in both…
-
Difficulties Nesting formula
Hello all, I think I am close to the answer here but struggling to figure out what I need to add to the formula to. Looking for the formula guru's here. Here's what I need this formula to do. I think I am on the right path, hopefully. If "Lab Date Received" row is empty, return "Awaiting FER in Lab" If "Lab Start Date" is…
-
COUNTIF multiple Criterias
Hello there, i am trying to count the number of time certain names have been selected in a multi drop down list, in a specific range of time, while referencing another sheet. I've tried the formula below and getting an error =COUNTIFS({Phase}, CONTAINS("Complete", @cell), {Go live date}, >=[Column10]@row, {Go live date},…
-
RYG "Yellow" Error for Health Metrics in Summary Row
Hi Community, I am trying to create an overall health metric for a project based on the information in the summary row of the schedule. The criteria is a mix of fields: If the Status is on Hold = Blue If the Status is Complete = Blank If the Finish date has passed = Red If Today is within 7 days of the Finish Date and %…
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
Using COUNTIF only if it qualifies...
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, {Team Movement Range 1"Donald Duck"}1). In the pic below Donald has 2 courses assigned…
-
Auto delete data from a cell once triggered?
Hi does anyone know if there is a way to delete data in a cell once that cell is triggered using a Zap? I was directed to Zapier, but man...I'm a newbie there. Has anyone done something similar? Basically -- am using a ranking system to prioritize projects. Once projects are prioritized, I would like to pull them out of…
-
Workflow not Triggering
I have a move workflow that should trigger when a checkbox is checked. The checkbox (picture below) has the column formula: =IF([Row#]@row > 50000, IF(IFERROR(MATCH([Row#]@row, {QC_Results_DB Row#}, 0), 0) > 0, 1, 0)) This formula triggers correctly, and checks the box when it should. The issue is that the workflow isn't…