-
Linking cells from multiple sheets to a report
Let me describe what we're doing: We are an agency that has several creative agents working on projects for our clients. Each creative logs hours worked on projects. We need to be able to count the total hours worked by all agents, then report that to the client report in one cell. Does that make sense? So if we have 5…
-
Card View: Color Cards Automatically Based on Parent
Is there anyway to color cards based on the parent task? I can't seem to do this in conditional formatting and was hoping to find another way.
-
COUNTIF formula across Multiple Columns
I am trying to count the number of times an individual's name is input across multiple columns. For example, an individual may be an "Account Manager" on one project but a "Project Manager" on another. I want to count the total number of projects this individual is involved with, regardles the role. Below is the formula…
-
Hours tracking conundrum
Hello, I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one…
-
Automating Balls
I have a formula that works for some of the functionality. I am having an issue getting the gray ball to work using this formula. =IF(AND(TODAY() - [End Date]4 > 0, [% Complete]4 < 1), "Red", IF([End Date]4 - TODAY() < 4, IF([% Complete]4 >= 0.9, "Green", IF([% Complete]4 > 0.5, "Yellow", "Red", IF(AND([End Date]4 <=…
-
IF Statement
I am currently working on an IF statement for RYG. I currently have a statement that turns green if the task is not on the due date and in the future. I have it turn yellow on the due date and red when past due. I am trying to get the IF to work adding grey to the mix that if the column done (checklist) is marked that it…
-
Hide columns when drop down menu it a specific item
I have a project sheet that has the tasks, actions, risks, etc. The risks have specific columns that apply to it. I want to hide these columns unless the item type is risk. I have searched for help with this but can't seem to find the solution.
-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children below…
-
Automating Grey Ball
I am having an issue getting the grey ball to work when a task has been marked done. The formula that i have is below. If will only work if the date is older than today. If will change the balls to other colors depending on the dates even if the task is marked done. Any suggestions? =IF(AND([Due Date]1 < TODAY(), Done1 =…
-
Formula to check percentage total
Hi I have a sheet which is pulling through some data from other sheets via cell links. The cells are being pulled from a Project Plan (with rolled up section totals). Based on this data, I want to set some conditional formatting on my sheet. I have: %COMP STARTDD ENDDD 55% 10/08/16 22/08/16 I'm using a formula (hidden…
