I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my backgrou…
Hi All, I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-…
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I …
Hello, I have a Master sheet, into which information comes every day via a form. I also have a Wrap Up sheet which pulls specific data from the Master and manipulates them via a formula into a number …
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "a…
Hello, I have a Master Sheet and a Roll Up sheet based on the Master. The Roll Up uses a lot of formulas, including the "TODAY()" function. Apparently, the Roll Up will NOT refresh to reflect the data…
Hi, I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final …
Hi, I have a sheet with several formulas, including a =vlookup on a text cell and =Join (). All these formulae autopopulate when a new row is added manually of via a form submission. However, I also h…
Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say i…
Hello! I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13). I want to display the cur…