-
Formula referencing another worksheet
Hi, I am trying to create a formula to determine how many tickets are in a Category and have a due date within the next 30 days. I am trying to do this outside of the worksheet so when creating my formula I need to reference back to this sheet, however no matter what I try I'm still having the same issues...…
-
Using INDEX/MATCH with images
Hi all, Is it possible to use an INDEX/MATCH formula to bring an image from one sheet into another? If not, anyone recommend a solution/ work around? I am building a new sheet that utilizes INDEX/MATCH to bring in info from several others and I would like to be able to bring in these images from their source document.…
-
Count Between Dates
Hello, I need a formula that identifies how many rows I have per quarter. Example; Q1 from Jan 1st to Mar 31 of this year. Some help Please
-
Cant get a countsif formula with multiple phase helper sections to work.
Hi I am trying to count project health indicators , But only i certain sections of my project plan. I can get a basic countsif formula to work: =COUNTIFS({Project Plan - Health}, =Metadata@row) + 0.0001 I can also get it to work with just one section : =COUNTIFS({Project Plan - Health}, =Metadata@row, {Project Plan - Phase…
-
Find and Return
Good morning gurus! I need some magic to find a return all instances of information in an external sheet. For example, I need to find all instances of "ABC" in the Material Name, and return the associated Batch number. All the formulas I try will give errors or only give me the data for one instance. Any ideas? Thanks in…
-
COUNTIFS on specific days and net change over time from report
Hello all, I am struggling on finding a solution for this. From our calendar, when we have issues, we log the issue in the notes section, categorize the main issue, and change the "Incomplete Job" column to Job down or go back. When the "Incomplete Job" changes, I have an automation to record the date in the column, "Date…
-
Formula to Sum Specific Amounts
Putting it mildly, I don't understand formulas. I'd like a formula that will total all amounts when the word "Billed" is in the same row. Then another formula for when the word "Originated" is in the same row. For example, every time I add a new month's totals, I'd like the YTD totals to update. I tried this, but I really…
-
Searching for the nearest date in another sheet
Hi everyone, I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried Index and array but it seems not to work. Would appreciate a template. "Today's Date" cell is based on a formula, I inserted…
-
Round returned date to working day?
I've been using a formula to calculate due dates, which are always 90 calendar days from the original date column. This is the formula: =IF([Resubmission Required?]@row = "true", [Date Decided (Approved/Rejected)]@row + 90, "n/a") However, because we are required to calculate these dates in calendar days, many of the dates…
-
Automated symbol isn't switching
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green. This is what I got: =IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target…