-
Filter Helper Question
Hello, I am tracking communications for my project, and each row represents a communication (e.g., notify employees of changes to expense policy). I have separate date columns for "Draft Due" and "BU Review Due" and "Legal Review Due" and "Distribution Complete" (see attached). I want to have a filter to show me any rows…
-
Most Occurring Value Based on Multiple Criteria
Our organization is counting how often we interact with clients weekly and that process is going great. What I want to do is show who contacted the most clients during a particular week. We have a data dump master sheet and a sheet where I consolidate some high level data. With this one I don't even know where to start…
-
Matching data from one column in Project Intake Sheet to another column in Project Metadata
Hi so I am currently redesigning a project tracking system for a company. I downloaded the PMO template set to use to get a foundation but it will not track the data i need it to track. Basically what I need help with is I have multiple columns in the Project intake sheet that will have simple data put in them like dates…
-
#INVALID OPERATION is trying to break me
This formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1 FC Start Date (020) .LT/ET. the LOG 2 "End Date" and LOG 1 "Property State" = LOG 2 "Property State".…
-
=COUNTIF error
Hi there, I have some survey results on one sheet that I'm trying to pull into another sheet so I can build charts in a dashboard to display the trend in responses (i.e. how did people respond to question 1, question 2, etc. for each event). The survey includes a drop down to select the event the respondent participated in…
-
Change Past Date into Month as Written Text
Probably a simply question but I'm looking for a formula that is able to read dates in the past, and then fill a different cell with the month as text only. e.g. The first 'offline' date would populate the offline month with 'October' Thanks
-
Changing State Based on Criteria.
Hi all, I think I have some syntax incorrect in my code and hoping for some help. Currently, I have a formula that sets the State of a task based on % Complete: "=IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete")))" I also have an…
-
Does INDEX only work with entire column as a range?
To be clear, the correct syntax for INDEX is: INDEX(range, row_index, [ column_index ]) I have several working examples of this function across many sheets, including cross sheet formulas. I also know about using INDEX with MATCH and /or COLLECT to select the appropriate cells based on other criteria. Up to now, the range…
-
Update Formula to Check for Blank Value and Use Static Value in its Place
I have a sheet that my company uses to track when a resident is being moved from their apartment into a temporary apartment and a permanent apartment while we renovate our apartment buildings. Each resident has one row, with columns to track their original unit, original unit move out date, temp unit, temp unit move in and…
-
RYG Status Balls Formula Help!!
I am looking for help developing a formula for the following RYG Status Balls Conditions: If status is "not started", grey If it is 1 day before "due date" and status is NOT "complete", yellow If it is the day of the "due date" or past "due date", red If status is "complete", or "in progress" and it is 2 days or more away…