-
Index and Match formula with a contact list
I'm trying to return the assigned colleague by using a match function between the project sheet & our source resourcing sheet. I've used this exact formula connecting two other sheets and it worked great. This time it is returning the correct value but it is NOT pulling it in as a contact which means the "current user"…
-
How to count a singular thing in a multi-drop down response list
Hello, I'm trying to count a response to the question community services a patient receives, there are multiple different choices as you can see here to the left. The problem that I'm having is when I'm trying to find the number of "Outpatient therapy" responses I'm only getting one. Here's my f-code. =COUNTIF({SOC…
-
Circular issue with countifs formula
Hi, I have a circular issue with the formula below: =COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], >0) I tried this, same issue: =COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy,…
-
Today minus a date field
What am I doing wrong? =Today() - [Column 5]@row Column 5 is a date field. This is giving me an #DATE EXPECTED error
-
Autofill cell with a value based on another cell's value while still allowed to select from dropdown
I have a Sheet with 3 columns that have a restricted dropdown list: 'Not Started' 'In Progress' 'Rework' and 'Complete'. Column 4 has a restricted dropdown list: 'Submitted' 'Resubmitted' and 'Rework' A 5th column has a restricted dropdown list: 'Approved' 'Pending' and 'Revise & Resubmit'. I want the first 4 columns…
-
IF statement to update "Health" column base on "State" and "End Date"
Hi everyone, I'm trying to create a formula that: If state is not complete and end date is in the past, then health column will show ⏰ State - Drop Down menu: Complete, In Progress, At Risk, Blocked, Not Start Thank you in advance!
-
How can I search another sheet for a name match within a certain date range?
I'm struggling to create a formula that will not only look for a name match from one sheet to another, but it will only return a match if the date on the row was within the past 6 months. For finding a name match between sheets, I've been utilizing the following formula: =IF(CONTAINS(Contractor@row, {Change and Offboarding…
-
Multiple IF statments
I have a probability column (High, Med, Low).. when updated to one of these I want it to apply a predetermined percentage to a sum of rows (projected sales). Example, Projected Sales =Sum of columns 1-4, If High I want the sum to be multiplied by .75, if Med by .5 and if Low .25. I can get this formula to work for one…
-
IF statement to update a Completed field - looking at multiple criteria
I'm trying to update a Completed column with a formula. I need this formula to to look at the following columns: CW Sent (checkbox column) Event Date (date column) Private Date (date column) Online Date (date column) Criteria: 1) If CW Sent is checked and Event Date is in the past or today, mark Completed or 2) If CW Sent…
-
Updating parent status from child rows in separate columns
Hello. I'm looking for a formula to update the Project Type column in a parent row to identify as "Digital" based upon specific contact entries in the Assigned To column in the child rows. For instance: -child row Task 1: Assigned To Employee A -child row Task 2: Assigned To Employee A, Employee B, and Employee C -child…
