-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Trying to accurately gather % complete based on statuses and excluding N/A in children rows
Hi all! I am revamping a project task list template that my team uses each time we are building a new location. We'd like a high level completion status for each department involved in these projects, but I'm running into a bit of a hiccup with my formula. In the Status column of the departmental parent rows, I am using…
-
Smartsheet Company Wide Training
I am trying to find any training material that Smartsheet has that I can leverage for company wide training. I will be organizing our training/implementation/roll out plan to ensure all necessary employees understand the tool and can hit key milestones within Smartsheet. I know they have lots of training videos, but just…
-
Formula to Change Harvey Ball Color Based off of a Word
I've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbiage: Example: I change a cell to Rejected and the ball turns Red. I change the same cell to…
-
Pulling Data from Second Sheet
Two Sheets: I have one sheet labeled "Permits" and one sheets labeled "Project Tracker", Each sheet has a Column Labeled "Job #" and "Permit #". What I'm looking for is if Job # match on both Sheets in column, Permit number column on Permits sheet is copied to project tracker sheet column.
-
Representing activities/tasks that may be associated with multiple domains
Hi - I am creating a complex project plan where I have identified domains (highest level), workstreams, and then activities. There are certain activities that may be associated with multiple domains or workstreams. Any tips on how to represent activities that are linked to multiple higher-level categories without just…
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Resource view
Can I zoom out on the resource view to show the timeline by month and quarter and not just week, which is the default?
-
Wrong date format on hyperlinks
Hello all, I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displayed in US date format. Is this a glitch or are we doing something wrong? Tom
-
Formula for changing drop-down selection in one column when a date is entered in another column
I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?
