-
Key Milestones / Deliverables - Output
I am using smart sheets for project planning purposes. Each plan will have hundreds of tasks. About ten of these tasks will be what I class as a 'key milestone / deliverable'. I use another system (Salesforce) to show a graphical representation of the status of each of my projects (Tasks, issues, risks, budget, next steps,…
-
Is there a way to merge sheets into one calendar view?
Is there a way to merge sheets together to show scheduling impacts in calendar view? I'd especially like to keep the coloration of each sheet to quickly identify projects. Anyone know if this can be done and how?
-
today() function
I want to create a formula tht creates a Datestamp of when a checkbox is clicked. If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clicked? Thanks, Shaun
-
Dependencies
Hoping someone can help puzzle out a way to make this work! I'm trying to find a way to show the original estimate at the beginning of the project compared to the updated estimate based on how the project is going, without having to refer to the version history (so we can run alerts and formatting and such.) Essentially…
-
Next working day calculation
Context: I've a Smartsheet that, given an agile software release number in the form of Year.Week.SubVer that calculates the release date based upon the first Monday of the Year (SubVer = Day of week, 1=Monday, 2=Tuesday), so 2015.18.1 = 4/27/2015 (and 2015.18.2 = 4/28/2015 etc) What I'd like to do is be able to somehow…
-
Managing Deadlines for Marketing Department
Our marketing department handles the event marketing and promotions for a company that puts on 14 road races. Each race's deadlines over lap with the other race's deadlines. Is there a way to see all the tasks from multiple sheets on one sheet but sorted in order of deadline?
-
Repeatable Task
Hello, Is there anyone using a Smartsheet for employee leave or schedule tracking that has found a way to create a repeatable event such as a reoccurring schedule or leave (like telecommuting or alternate schedule). Thank you, Jay
-
Publishing a Calendar to Google
I have published calendars to google several times by going to calendar mode in SS and selecting the "Publish to Google Calendar" button then selecting "ON" and it shows up on Google under "My Calendars" . But my problem is that one employee is trying to publish a calendar to Google but it will not show up as one of their…
-
Calendar Coding Possibility
I am a project manager and assign items to various vendors. I am wondering if there is a way to have the vendors color coded in the calendar view, so that I could look at one calendar and know who has bandwidth? My workaround is to add information in my master sheet and then add to each vendor's sheet; however, I would…
