-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
Conditional Formatting Key or Legend
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
-
New Feature Request for Coments
It would be helpful if there was a way to flag a comment as complete. I would like to see a way to turn the Comment box for a row green (or any color) if the Comment has been completed or resolved. This feature would be very helpful for me to see quickly which rows or Comments needed to still be addressed. I am a very…
-
Apply Conditional Formatting to a Workspace
Is there a way to apply conditional formatting to an entire workspace, when sheets are identical in set-up, column type and layout? Thanks
-
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…