-
IF and DATE functions
I am trying to return an anticipated completion date of 2 weeks from date of request if the vendor is existing, and 4 weeks from DOR if the vendor is new. I have a Yes/No column for whether the vendor is new. I can't seem to work this out with an IF function. Any ideas?
-
Lock cells that contain formulas
Hello, Is there a way to lock cells that contain formulas? I ask because although there is a way to lock columns/rows, I've found that (all parties w/Admin privileges) you can accidentally click on a cell and change the formula. Cheers. 😀
-
CountIf and Multi Select columns
I am trying to count the number of instances a value appears in a multi select drop down column, but I keep getting an unparseable error. After searching the existing help forum I have tried both the CONTAINS and the HAS functions as follows, but receive this error for both of them. The formula's I have tried are:…
-
How do I update the year based on status change?
I want to have the year updated when the project status changes to Complete or Cancelled to insert the current year to be automatically updated in the Archive Year column. The column is currently set as a single dropdown with all the years listed, but I want to build a formula to automatically change the column to update…
-
Formula previously worked, doesn't now
Hello! This logic seemed to work in a different capacity, but no longer is. I have the three categories used locked to check box only. Help welcome! =IF(AND([Sent to VP for Signature]@row = 0, [Returned to Requester]@row = 0, [Fully Executed Filed]@row = 0), “Red”, IF(AND([Sent to VP for Signature]@row = 1, [Returned to…
-
Conditional Formatting a Sum in a column
I have a report that sums employees healthy living reimbursement requests from a sheet gathered from a form, the report has a column that sums up each employees requests. Employees are only allowed $1000 per year, I would like the report to highlight anyone that has a sum of $1000 or over....is that possible?
-
Duplicates based on Doc ID and Date
I am trying to write a formula that will checkmark a box if 1 cell matches any other cell in the same column and they both have empty dates cells. I keep getting an unparsable error. I only want to see if there is a duplicate request in cell 1 if they haven't been completed. Empty dates means we are still working the…
-
How do I calculate within last 60 days?
I am trying to calculate a sum of numbers in a column within last 60 days for a report and a dashboard. I am trying to use this formula but it is not returning anything accurate. =COUNTIFS(Date:Date, <TODAY(-60), [Total count]:[Total count], 1) Total count is the column that I set up to count if the other checkbox column…
-
SUMIFS statement
Hello, I am trying to use SUMIFS to pull reference a numbers on another sheet. I want to say if the PO number is = X, pull the invoice total from the invoice total column and Sum it in this column on another sheet. (So I can see a sum of total put to that PO number). Any help would be appreciated! Thank you!
-
If Then Statement
Hey all. I'm trying to figure out this formula, but keep getting Incorrect Argument Set. I need it to pull the close date +180 if the Type column contains CDM. Thank you in advance for your help! =IF(Type:Type, CONTAINS("CDM", @cell), [Close Date]@row + 180, "")