Does anyone know how to write this formula correctly?
Basically, I've got a "completed" column that is a check box column. I've got a "priority" dropdown column with several different levels of priority includeing "none" so that I can sort my reports via priority.
I'm trying to create a tally of the number of rows where a specific column contains a string. For example, the contents of a cell = "6-1, 6-2, 7-2" and I want this to be counted as 6-1, as 6-2, and also as 7-2. If this row were to only have one designation, so cell = "6-1", I could do this easily
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same
I need to schedule a row-by-row reminder 8 weeks in advance of the row start date. I've looked at the 'alerts' feature at the bottom of the sheet but it looks like the maximum I can send a reminder in advance of the start date is 14 days. Is there a work-around here?
I'm evaluating duration time of every tasks. In the sheet, I set a duration time, a start date and the end date is adjusted accordly. If I want to change the start date, the end date will be updated and vice-versa. It's fine.
However, in the Gantt chart, when I'm touch a gantt bar to