-
Account by month
I have a list of accounts that we are migrating to a new platform over the next two years. Here is a portion of my list. I need to replicate a view to something like this slide. Any idea? I have read everything posted online and watched 2 hours of videos on this today and cannot even come close. I would appreciate any help…
-
Project Tracking that includes working day tasks and calendar day tasks
Hi All, I am attempting to manage a project that includes tracking tasks that follow our company's cultivation process in addition to production tasks. As most of us know, plants don't take the weekend off... Has anyone found a good workaround in project settings to account for this kind of project tracking variability? We…
-
Formula to Capture Active Projects Assigned to an Individual ONLY
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure it so that it counts the number of projects by assignee IF the project status is one of the following: Not Started In…
-
Formula to calculate difference between projected and actual dates
I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit date and actual submit date? Is there a formula that will automatically select the…
-
Character Limit - Need More Characters
Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.
-
Vlookup w/ Checkboxes
I'm trying to link two sheets via a Vlookup equation. I want the formula to search the indicated sheet for an unchecked box and return whatever column I indicate. I can make my equation work if I substitute numbers instead of checkboxes but I cannot make it work if I look for a check/unchecked box. What am I missing?
-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3weeks from the due date will show in that column and so on I appreciate your help Rob
-
SCC provisioned projects connected and linked, but Summary sheet not showing actual linked cell data
I provisioned a large number of projects and everything seemingly went well. As i start to look around more im finding some oddities. One in particular I don't understand at all... The project provisioned successfully. The data is all there without errors. The summary sheet rollup shows the project with successful (blue)…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…
-
Changing dependency line colours
Hi, I've previously been able to change a dependency line colour from the default black to any other colour. Now I can't find this feature - has this been removed? Pretty sure it was right click on the dependency line, similar to the right click option on a Gantt bar. Thanks
