-
Dates not lining up
My editorail calendar isn't lining up when I sort by date. My April dates are below July. I'm not sure what's happening with the formatting.
-
Counting Child Rows of Un-Checked Boxes
Any tips in how to count child rows where the check box is not checked? I tried CountIF but it does not seem to work Thanks Elaine
-
Conditional Formatting based on a cell text formatting
Hello hive mind. I am familiar with IF statements and Conditional Formatting, but I am not seeing a way with either of those for the followng. I would like to set a Conditional Formatting Rule to highlight a row to a certain color if the text in a particular cell is in bold. There does not seem to be a way with Cond. Form.…
-
Add number of months onto a date
I have a sheet that summarizes all of our projects. I want to add the projected term of the project (in months) to the kick off date of the project. Here is what I came up with but it is not working: DATE(MONTH([Kick Off]1) + [Project Term]1) Is there a formula that I can reference the date on one cell and add...say "6…
-
Star Ratings/ Symbols - changing amount?
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…
-
Holidays over multiple projects
Hello, Is there anyway to default dependences so that when you start a new project sheet the dependences are already set? I am currently setting up multiple projects and having to enter working weeks, hours per day and holidays is quite time consuming.
-
Formulas lost when moving rows within sheets
I keep an 'active projects' sheet, and move projects to an 'inactive' sheet to keep the clutter down. The formulas do not move with the rows though, which is annoying (sometimes projects come back to the 'active' sheet when new samples come in, and I am now having to copy and pasting formulas into those cells). Any…
-
Formula Assistance
I’m sure I’m not the first to ask this. I could not find a post addressing my question. I am creating a sheet to track invoices through a department; receive to payment. I created a check box column titled 'January - Invoice Received' when the check box is checked i want the next column over titled 'January - Invoice…
-
Help Needed! - IF rule
Hi,, I am trying to total a column based on whether a value has been entered (but to ignore the actual value), giving a total of the cells with values in. Something along the lines of IF value greater than 0, to count that as 1.. Help would be greatly appreciated if anybody knows the formula?? Kindest Regards, Ben
-
CountIF and Sights Auto-update question
Started using Sights this week, definitely a very cool feature! I've seen some things in the example gallery that I'd like to know how to do. 1. From the Sales Pipeline example in the Sights Gallery, I’d like to have Totals by Month for: Status (Green, Yellow, Red RYG balls) Stage, Rep and Segment (all drop down columns on…
