-
Current user + formula in Contact List?
I'm trying to auto-assign an owner to a task based on the task type: The Owner column is a Contact List Column and the email addresses specified in the formula are associated with current user accounts (one being myself). But when I use a Current User filter, nothing shows! I can only assume that using a formula to fill a…
-
Sum Function Error
I created a resource planning sheet to track each employee's workload. I have Workload Rating automatically changed to 3, 2, or 1 based on the Engagement Level. Lead = 3, Core = 2, and Ad Hoc = 1. I also have a Total Rating to sum up the Workload Rating. However, it returns a 0, for example, for Employee 1, the Total…
-
Calculate Status Column by %Complete
Trying to set status column based on % complete - I can make the formula work with just the first statement - =IF([% Complete]@row = 0, "Not Started") =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row >= 1 < 100, "In Progress", IF([% Complete] = 100, "Complete"))) Anyone know how to make the above formula work?…
-
Need Help with IF, AND to create a Health Matrix that is based on DATE & % Complete
I have figured out most of the equation to display the health of a task but I can't figure out how to get the Last criteria figured out. Sample Case: Task is 10 days in duration 1. Health is "Green" up to the 5th day. 2. If the task is below 50% complete and past 5 days then "Yellow". 3. If the task is above 50% complete…
-
SUMIF formula confusion // help?
I am reaching out as I am getting a little confused with a SUMIF problem. I've included a screenshot below to help illustrate. So, the blue parent rows represent delivery phases and the device list at the top is the total contracted device count we get from a client. The goal is that when a person enters a shipping…
-
Record date the box is checked
Is there a formula that records the date when the checkbox is checked? I need to track this and right now I just do it manually by right clicking in the cell to see when it was edited. But it would be awesome if I could create a formula to show me when that box was checked automatically.
-
Forumula to pull oldest date in a column
I am trying to pull the oldest date into into a dashboard. I have my metrics sheet and keep getting the #invalid Column value error. I am using the MIN forumula and referencing the column on my sheet. =MIN({Depot Repair Collection Log Range 1}) Any clues or anyone have a sample formula I should be using. I made sure the…
-
Need some assistance on using "IF(AND) logic. I'm trying to render a "Red" "Yellow" or "Green".
I'm trying to render a "Red" "Yellow" or Green" solution from more than one criterial. Formula reads this way. =IF(AND([% Complete]25 < "1", [End Date]25 > TODAY()), "Red", IF(AND([% Complete]25 < "1", [End Date]25 = TODAY()), "Yellow"), IF(AND([% Complete]25 = "1", [End Date]25 = TODAY()), "Green")) Essentially I want to…
-
I want to set a formula that only picks up the last 7 days
Can somebody please help me with a formula to pick up some conditional data? e.g. =COUNTIF(Column 1:Column 1, "SOLD") .....and then I want to add a condition showing entries in the last 7 days (including current day)
-
Formula to place a date in a cell that is greater than a date in another cell by "x" lead time
Hello again community, Just wondering if somebody knows how to write a formula that could look at a date in a date ordered column and place a date in another column that is greater by 30 days. From this point, I have an idea to have a formula tick a box based on whether this date is today and then have a conditional…