-
#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"…
-
#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.…
