-
How to put contact list names into a visual graphic from a multiple contact column
Hello! I have a tracker for my project team that shows all active projects and their details. One of the columns is called "Project Team" where the PM is asked to list out all individuals who are on their project team. The column lets them add as many team members as they need to. I have been asked by my Director to turn…
-
Bi-Weekly date formula.
Thank you in advance for any help on this! So, I am using this formula: "=TODAY() + (6 - WEEKDAY(TODAY()))" to show a weekly task that is always do by Friday every week. I like this one because each Sunday it updates to the current week automatically, making so that this task it is attached to shows up on the calendar for…
-
Point Tracker System
Hello, I am wanting to build a system for tracking points. There are two kinds of points: good and bad. Simply put, I want to keep an up to date tracking for each employee. Here is what my starting base is: Now here is where I am getting stuck. How do I make it so that I can reference a specific employee's total from a…
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…
-
Reset Value to 0, No negative numbers
Is it possible to have a number go down the 0, but not have it have a negative value? I'll share my sheets to illustrate. So this is my current sheet. I am running into an issue where people are having a negative total (picking up a ton of OT shifts) and they accumulate a big negative total value, so when they do no-calls,…
-
COUNTIF Formula for Multiple Statues and Conditions
Hi, I'm struggling to have a working formula that would meet the conditions I am trying to have shown. The 6 statuses are: Not Started, In Progress, Completed, Cancelled, On Hold, Delayed So here's the logic I'm trying to apply: If all children are Not Started, the parent is Not Started If all children are In Progress, the…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
Index Match
Hi there, I need help with creating a formula for using Index Match What I want to formulate: If California is selected from the State column dropdown, I want it to index match and reference another sheet to pull record # based upon email. (Bar Number CA is the same as Record #) Current formula:=IF([State Column]@row =…
