-
Changing a Date (mm/dd/yyyy) to Month Year (January 2019)
I copied this from another post and simply substituted my date range (from another sheet) and It is returning "UNPARSEABLE". Any suggestions? =IFERROR(IF(MONTH(@{Quality Database Range 1}@row) = 1, "January ", IF(MONTH(@{Quality Database Range 1}@row) = 2, "February ", IF(MONTH(@{Quality Database Range 1}@row) = 3, "March…
-
VLOOKUP not allowing me to return value from beyond Column #20
Hello - I'm using VLOOKUP to return values from two separate data sets based on a unique identifier for my projects. For one of the VLOOKUPs, the column_num (column that I want to return the value from) is column 27. Why is it that VLOOKUP will return any value from columns 20 and below only?
-
Help with Flag formula
I've tried a few different formulas using IF and ISBLANK but can't seem to figure this out, even after looking at a few post on here. Hoping you can help. I need help with creating a formula for the following: If a task is incomplete and the due date is in the past, a red flag will appear BUT if the 'due date' cell is…
-
Count "Yes" and Return Percentage?
I am trying to create a "scorecard" of sorts. I have seen the formulas that allow you to count the number of "Yes" and return a value. But can you return that value as a percentage of responses? For example, say I have 5 columns with drop down answers of "Yes" or "No". Assume four columns were "Yes" and 1 was "No"; That…
-
Using COUNTIFS with multiple conditions
Trying get a count of issues in a catergory sheet that is referenced from a main sheet and then add another condition to count the categories of only the ones where the site is checked. The first COUNTIFS works, but not the 2nd one like below . =COUNTIFS({Day 1 Support Log Range 1}, =[Issue Category]1, {Day 1 Support Log…
-
Networkdays and #invalid data error
Hoping you can help with the below formula. I need to return zero and can not get the iferror formula to work. current formula is =NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4). Screenshot included for reference. Thanks, Heather
-
If Statement Comparing Date of Text Entry Between Columns
We work from a running tracker were there are a series of dates (entered as text, not an actual date) are entered into different columns to signify when certain steps have been completed. I am trying to find a way to automate a flag or alert or something to designate how many days go between each step so we can easily see…
-
Count and compare date columns in 'form' based worksheet
I would like to know how I can count number of activities (rows) which are completed ('finish' date column) at or before 'planned finish' date. In the same formula it should only be counted when 'complete' column is ticked off and empty cells should not be counted. Note that this is a 'form based' worksheet, meaning rows…
-
Look up blank cell and add a value in another column on the same row
Can someone show me how to write a forumla that will look up if a cell in the column "Critical date" is populated enter 1 in column "CD2" on the same row. Essentially what I'm trying to do is run a report that summarises all my critical dates but I can't select that date column in my report. If there is a better way I'm…
-
Formula Assistance - Duration of Activity at Specific Rate
I hate math, so am asking the Community for some help. Looking to build what I think should be a reasonably simple formula for someone that doesn't hate math. Here's the Word problem: We have equipment that scans files for malware at the rate of 77,000 files per day. Apparently it doesn't matter if the file size is big…