-
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
-
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
-
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…
