-
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 =…
-
If Has on multi select with an Index/Match
trying to get this to work.. but failing on correct syntax. =IF(HAS("California", State:State), , IFERROR(INDEX({DS-Record #}, MATCH([WSGR Email]@row, {DS-Email}, 0)), "")), IF(HAS("CA", State:State), "") ultimately, we have a multi-select option on the form, if they select multiple states we want it to look up their bar #…
-
Nested IF/INDEX/COLLECT
Hello, I’m looking to add to an existing formula. The formula below checks if the Country and Instructor Currency match and pulls in the Fee if it does match, or the Converted Fee if it doesn’t match. The formula also matches the Instructor Name, Course and Format match. This has been working great where I have an…
