-
Count and compare date columns in 'form' based worksheet
I would like to know how I can count number of activities (rows) which are completed ('finish' date column) at or before 'planned finish' date. In the same formula it should only be counted when 'complete' column is ticked off and empty cells should not be counted. Note that this is a 'form based' worksheet, meaning rows…
-
how to see the collaborators ?
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest? See images please. Thanks
-
Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
-
IF THEN formulas for status balls
I am trying to use an IF THEN formula to show status balls. I have a "due date" column and a completion column. If the date in the completion column is more than 7 days later than the date in the due date column, I'd like the status ball to be red. If the date in the completion column is within 7 days of or before the date…
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
Resource Forecasting
Here's what I want to be able to do for resource management. Is there a workaround to accomplish this? * Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to multiple individuals does not work for me. * Each individual has default work hours. E.g. 8 hrs. It can be modified if needed…
-
Gantt View - Settings requests
Hi, I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete. I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was…
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…