-
Want to Calculate Crew Required Based on Specific Dates
Below is the screenshot of the formula I am trying to use but it always returns 0, Please guide Thanks!
-
Formula for automatically pulling rows of data from one sheet to another using checkbox
Help please 🙏 I need a formula or solution for automatically pulling rows of data from one sheet to another using a checkbox... So sheet A has a ticked checkbox, meaning I need the information from most columns in the ticked rows moving over sheet B every time a sheet A checkbox has been ticked.... (I need name about 5…
-
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…