-
Nesting IF Formula
I am attempting to create a tracker and the current formula is creating the dreaded "#UNPARSEABLE". I essentially am trying to autopopulate a number into column two, based on the name entered into column one. When I utilize the formula =IF([Employee Name]1 = "John Doe", {Employee ID Numbers Range 1}) it works fine. But…
-
Editing Formula
Hi there, I have this formula in the Schedule Heath column (picture of sheet listed below). Currently, the default value for cells in the Schedule Health is Red. I want to change its gigantic formula so if the End date is blank, the schedule health stays blank too (instead of red). Appreciate your suggestions. Thank you!
-
Iferror(vlookup) not pulling all data from a cell.
I am using the Iferror(vlookup) function to track my teams inspections. Recently, I changed the form to have multiple locations, and since then the iferror(vlookup) is not pulling every locations date from the data set. Picture 1 is an example that pulls the data properly, picture 2 does not pull the data, and picture 3…
-
Count distinct values within cell
a
-
Column IF AND Function Help
Hi all! I cannot seem to get my IF AND statement to work and would sincerely appreciate some guidance! I am attempting to alter/update a cell on one sheet that acts as a matrix for employee training which is based upon information from a reference sheet. Essentially, a row in the reference sheet is populated every time a…
-
Notification When a Date Changes
I am trying to work with formulas and notifications so that if a person does not change a date in a cell, then they are sent an email reminder. Once they change the date in the cell, they won't be sent the reminder. In the picture above, somebody will manually enter the Due Diligence Date. The Site Development and Hard…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…
-
Combining IF functions to read multiple columns and create a flag
Hi all, I am working with the attached sheet trying to create a few flags to appear when certain information is present. The 3 flag columns are '2 Weeks - No Data', '2 Weeks - No Check Ins', '2 Weeks - No Paired Check Ins' and I have formulas within each reading the 'Check In Type' and 'Last Wk Check In' columns. Below are…
-
Question/Help with IF Statements
Hello, I'm working on a sheet for new employees and I'm trying to build a simple IF statement that will display whether or not the employee started, based on today's date. =IF([Start Date]@row = TODAY, "Yes"), IF([Start Date]@row = >TODAY, "No"))) I must be doing something wrong. Do I need rearrange the formula? I'm trying…
-
Update Formula to Include When New Columns Are Added
I have a sheet that tracks the number of hours by the team on each project. When a new project is created an additional column needs to be created (if anyone knows of a way to have it automatically added when a new project is created from a template that would be amazing) and named with the new project name. Then the Team…