-
Locking a Sum Formula
Hello - I am wanting to lock a sum formula and am not sure exactly how. Do I need to add additional aspects to the formula beside the "$"? The issue is people are moving items around in their timesheets which adjusts the below formulas and I want to make sure if they do this, the formula will not change. Below are the two…
-
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…
-
COUNTIFS and YEAR(TODAY()) not working
Hi, I'm trying to set up a formula, but the result comes up as #INVALID DATA TYPE. I'm at a loss of what's wrong with my formula. I'm using a very similar one in a different sheet and it's working. This is the formula that's not working: =COUNTIFS(City:City, City@row, [Event Year]:[Event Year], YEAR(TODAY())) And this one…
-
Automated Emails - From line taken from Form?
We have a form that is used to submit requests to a sheet. Upon the new row being added, an automated email is generated. Is there a way for the automated email to use the email address submitted on the Form as the "From".
-
Linking Summary Sheet Field Data Into an Existing Sheet to Report on Multiple Projects
Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding milestones, non-milestone status, and #of outstanding non-milestones. From there, I am…
-
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…
-
=(IF(AND(ISDATE INCORRECT ARGURMENT - HELP
I am gettng an Incorrect Arguement with the following formula and can't figure out how to fix it. =(IF(AND(ISDATE(Complete@row), ISDATE(TATS@row)), NETWORKDAYS(TATS@row, Complete@row) < 0, "1", NETWORKDAYS(TATS@row, Complete@row)))
-
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},…
