-
Formula to assign fiscal quarter not working
Good morning, I have been using a formula to assign a fiscal quarter to a row based on a date in another cell. I realized yesterday that the formula isn't working properly. This is the formula: =IF(ISDATE([Estimated Ship Date]1), IF(MONTH([Estimated Ship Date]1) <= 6, "Q1", IF(MONTH([Estimated Ship Date]1) <= 9, "Q2",…
-
Help on fiormula: countifs
Hi all, please need your advice for the correct formula for getting the count of projects that are active within a specific month? We would like to track the number of projects that are still active for 2018. I'm trying the formula below but I'm getting an #INCORRECT ARGUMENT error. =COUNTIFS(Stage:Stage, [Forecasted End…
-
If and date functions; sorting rows by priority
Hi, I am attempting to create a task priority column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change to: 1. Gray - if the date today is grater than 60 days from my due date column or if my status column has been changed to "Complete" 2. Green - if the date today is…
-
Automating RGB Balls from value scale
Hello, I am trying to automate into a status column a stop light symbol that reflects a value in another column that is on a scale - I am not sure what I am doing wrong... =IF([Health Score]12>= 0, [Health Score]12 < =1.5), [Status]12, "Red", IF([Health Score]12 >1.5, [Health Score]12 <=2.9),[Status]12, "Yellow",…
-
Escalation Alerts or Notifications
Is it possible - whether in the Alerts/notifications or with a formula, to create an escalation based on inactivity of entries. Example: Operators enter the date when equipment is cleaned. this is required weekly. If 2 weeks are missed for entries (14 days), then I want a notification sent via email to their manager.…
-
Converting text to date via formula
Good afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the cell in the appropriate "Confirmed" column is marked YES. There are 4 "Confirmed"…
-
#INVALID DATA TYPE formula Return
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
-
Building a red ledger
My apologies I am not even sure how to search of this, but I am trying to build a red ledger. Basically have it set up so there is a required sale every day and anything under, shows negative, anything over just shows zero. So I have 1 column that has the number sold, next is sum of column1 - 5000, the last is column2/100.…
-
Days Remaining Calculation
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
-
index match formula not working
Hi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a "contact list" column type, and the column used for the formula is a Text type. I assume the formula is not working due to the type, is there another way around this? =INDEX({Mfg Rev 18 area}, MATCH([Start Date]3, {start date…
