-
NETDAYS is giving wrong result
The NETDAYS between 5-Aug-2018 and 9-Aug-2018 is coming as 36530. I don't know what's happening - can anybody help? =NETDAYS([Last Date Entered]4, Today4) The same formula in another sheet is working absolutely fine.
-
Using COUNTIFS across multiple columns for one criteria
Hello All, I hope you are all doing well. I'm trying to use the Countifs formula by referencing our Portfolio Project sheet. I'm using five columns. One column is the project status which I am limiting to those projects with a status of "In Progress" (Range 1). The other four columns are columns that I titled, Project…
-
#circular reference error
I'm trying to use a formula to set a symbol column's (RYG Balls) cell color value based on a date cell, however, if the cell color has been manually set to Green I don't want the formula to do anything. For example, the cell in the formula below will default to Yellow. If it has been set to Green by the user, I want the…
-
Populating a Date field
I am trying to populate an Actual Start Date field with the current date when a checkbox is checked (Task Started). I am using the TODAY feature in my formula for my Actual Start Date. But what I am seeing that when I open my sheet it populates all of those dates with TODAY's date so I loose the actual date that the task…
-
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"…
