-
Select RYG color based on other cells
I have a sheet with checkboxes in 3 columns, and I'd like to have an RYG symbol in a separate cell be red if 1 box is checked, yellow if 2 and green if 3. If no boxes are checked I'd like to have no RYG symbol visible. I am assuming this needs to be some combination of IF and COUNTIF, but I have tried different…
-
Change Status Bubble Color Based on Percentage
Have tried using conditional formatting to achieve this with no luck. I have a column of % complete with percentages in increments of 5. I then have a seperate column of status that I am using a gray, red, yellow and green ball image. I'd like to for the color of the ball to change based on the percentage chosen (i.e. gray…
-
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.
