How can I change the dates in the gant chart view Month Day Year to Day Month Year? Thank you FJ
I have groups of tasks that ocurr in different projects and would like to copy rows that define those groups and insert them into other projects. When I copy them from one sheet to another, I lose the sequential dependencies between the copied rows. It takes time and and introduces errors to have to re type the…
Team, Is there any way to set up recurring reminders on individual tasks? Thanks you!
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
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 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?
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
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…
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…
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?
