-
Cells linking not working correctly.
Hello, we have a Template folder with a set of sheets which are all cell linked amongst each other, these have been working perfectly for 2+ years. When we get a new project in, we “Save as new” the template folder with the project number/name. In recent projects we have noticed cell links missing but just relinked the…
-
Linked Cell Not Working
Hello! We are linking cells from a project plan to a master sheet. Every other cell in the row linked just fine, except for the last one. It says that it is linked, but no information is being pulled into the cell. The cells in the project sheet are filled out and linked out to the master sheet: These are the corresponding…
-
Curiosity: Best practice use of symbols for health on projects
Hey all, I'm curious as to how others are utilizing the symbols for project health when tracking health task-by-task in a project. If you are using RYGB or RYGG, how are you indicating future state tasks? Gray or Blue is being used to indicate "Not Started" tasks or future state tasks Gray or Blue is being used to indicate…
-
How do I cusomize system generated date created?
This generates a date and a time. How do I customize so I just get the date. I can then use a formula to count across a date range. I cant if thee is a time in the cell too.
-
Changing the "Contact" function (Global Variable Please?)
Salutations, Presently, I am attempting to generate a productivity report regarding employee projects and workflows. I have utilized the Contact feature, as I'm only tracking/assigning tasks for Management level. No other users will use this or see it. However, we are unable to presently store sheet-specific data, as…
-
Date/Time Stamp Option
While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not scale very well as is. If you have a lot of rows you are wanting to track a lot of changes…
-
Maximum cross-sheet references
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards Steve
-
Why do my sheets not allow me to scroll all the way to the right anymore?
Minor ask, but very inconvenient... Especially when I am sharing sheets with colleagues who do not often use SS. As you can see in the screenshot above, I am scrolled all the way to the right, but the rightmost part of my last column is not accessible. I can hit my drop down button if I double click the cell, but this is…
-
Converting Cell Text to Hyperlink
Hi. I have a formula in a cell that generates the name of a course using text from other cells (e.g., BUS-430-BL-6W-1D-Master). FORMULA: =LEFT([Subject + Course]2, FIND(" ", [Subject + Course]2) - 1) + "-" + RIGHT([Subject + Course]2, LEN([Subject + Course]2) - FIND(" ", [Subject + Course]2)) + "-" +…
-
Milestone Duration Not Calculating Correctly
When putting milestones into a project plan, the duration is calculating as "1d" instead of "0" like it should. I cannot figure out why this is happening. Can anyone please advise?
