-
Date in a CountIf formua
I want a calculation that displays a summary of how many records have a complete date greater than or equal to 1/1/2017. Here is what I add to the cell: ="Unassigned: " + COUNTIFS(LOB:LOB, "ERx", [COMPLETE DATE]:[COMPLETE DATE], >=1/1/2017) Then I get an "Invalid Operation" messag and SS adds spaces to the date portion of…
-
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects. I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and…
-
Using time formula to create a master schedule
I am trying to create a sheet with a formula that calculates total time worked in a day, from a start time to an end time. I want to show who is working in specific units, from 8:30am to 7pm, at 30 minute increments for a 18 week period. See my pdf mock up attached. I created it in Excel. Any help would be a big help!…
-
Formula help!!
Please view the screenshot I have provided below. I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three…
-
Create additional dependency column to facilitate auto roll-up to parent
I created a new column "Effort". I want the "Effort" rolled up to the parent. That is not happening. One of the FAQ states that column must be a dependency column. However, I can only see "Predecessors" and "Duration", when I go to <Project Settings/Dependencies Settings> One way is to add a formula in the parent cell is,…
-
COUNTIFS with a date range and symbols
This is probably a no brainer for some of you with a lot more experience so I apologize ahead of time. For argument's sake, I have 2 columns. Column 1 we'll call DATE, column 2 we'll call SYMBOL. I'm looking to count the number of "GREEN" symbols that have a date greater than or equal to 1/1/2017. When I use the following…
-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
-
Imported sheet formulas not all working
I imported my sales tracking sheet and most of the formulas are working but some of them are not. this is what they say: #UNPARSEABLE#BLOCKED#BLOCKED Here is a screenshot of what I have in some cells. https://screencast.com/t/J1Rvx4iz0 I don't know how to fix this.
-
Summary Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row. I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way…
-
Formula IF Due date help!
Hi, I'm trying to do the below: - When a date range - TODAY () is less than 30 it shows 'Current,' - When a date range - TODAY () is less than 60 it shows '30' - When a date range - TODAY () is less than 90 it shows '60' - When a date range - TODAY () is less than 90 it shows '90' I can get it to say current, and it works…
