-
Counting Completed Tasks For Dashboard Report
On the project metrics sheet used for dashboard reporting, I need to count the number of times a particular task has been marked as completed using a checkbox. Here is a screenshot of what I am trying to count (see green highlight). Here is what this looks like on the project metrics sheet including the formula that keeps…
-
Symbols Column not Displaying Symbols per Formula
I have this JOIN statement that works but it does not show the symbols setup for that column. Any idea why? Your help is appreciated in advance! =JOIN([Previous Week Trend]27 + " " + [Previous Week Trend]30) returns Unchanged Unchanged
-
Keeping Formulas When Downloading to Excel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
-
Multiple 5 working days calendar
I'm trying to calculate end date based on multiple calendar working days. our manufacturing unit work for 365 days but employees in manufacturing works for 5 days in a week (they follow this working days: Monday-Friday, Tuesday-Saturday, Wednesday-Sunday, Thursday-Monday, Friday to Tuesday, Saturday to Wednesday, Sunday to…
-
Calendar/Form Integration and Automatic Emails
Hello! I work at a university. My team and I help coordinator several Dean's schedules and student meetings. The current process is extremely manual. Ex: Staff member is informed a meeting needs to be scheduled, staff member looks for openings, schedules meeting, sends confirmation email to the student and partner site…
-
Quick help on a formula
I know I'm missing something small and I cannot get this formula to work. Basically you throw a date into the "desired start date" and it will populate a small timeline of required milestone dates based on another sheet that's referenced. Works fine in our master sheet (right side in picture). However when I started…
-
Dynamic Date cell --> to feed into NetWorkDays formula
Hi all, I'm very new to SS and maybe am going about this backwards....GOAL: I'm trying to create a running countdown between the current day and the due date of a project. I figured out to use this formula: =NETWORKDAYS([Start Date]31, [End Date]28) BUT I want this number to dynamically "count down" as we approach the end…
-
How do I generate the same information that is entered in the parent, into the children?
I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is the deciding status, the status that matters. I want to show all projects that have a certain PM assigned, AND if the…
-
Formula @Row Question
I am trying to edit a formula for our naming convention column in SS. The below is our current formula. At the end it pulls in the year according to today's date. Instead we want to remove that and have it pull in a date (just the year) from our "Final Due Date" column. How would I edit the formula to pull that in? We…
-
Minimum Date in a range of dates that is >= Today?
I need a formula that returns the minimum date from a range of dates that is greater than or equal to today's date. I use the MIN function to return the minimum date in the range but, I need the minimum date that is greater than or equal to today's date. Today's date needs to be automatically generated so I have been using…
