Gantt View

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…","categoryID":321,"dateInserted":"2018-07-25T19:34:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-09-14T18:04:32+00:00","insertUserID":55716,"insertUser":{"userID":55716,"name":"Dynamics","url":"https:\/\/community.smartsheet.com\/profile\/Dynamics","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/b8\/17\/nb8175d34625842a6b884fd960471ab7b.jpg","dateLastActive":"2018-08-03T18:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":139880,"lastUser":{"userID":139880,"name":"CWats716","url":"https:\/\/community.smartsheet.com\/profile\/CWats716","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgxWiQy6jGfvPye3G2hdBzQzIBZCrSjsy5TzrwHyQ=s96-c","dateLastActive":"2021-09-14T18:01:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":2806,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/29276\/2-or-more-projects-sheet-dependency","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29276\/2-or-more-projects-sheet-dependency","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":46521,"type":"discussion","name":"Data storage EU","excerpt":"Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…","categoryID":321,"dateInserted":"2019-04-23T14:02:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-09-10T12:43:15+00:00","insertUserID":86336,"insertUser":{"userID":86336,"name":"MacGordon","url":"https:\/\/community.smartsheet.com\/profile\/MacGordon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-23T13:49:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":41501,"lastUser":{"userID":41501,"name":"Joachim Mund","url":"https:\/\/community.smartsheet.com\/profile\/Joachim%20Mund","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5zNCeZKbYDo!n8PAH775fLw!O6MnWziB8Y_","dateLastActive":"2023-04-02T14:21:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":513,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/46521\/data-storage-eu","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46521\/data-storage-eu","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":444,"urlcode":"card-view","name":"Card View"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":82952,"type":"question","name":"How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets","excerpt":"Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…","categoryID":321,"dateInserted":"2021-09-09T15:43:11+00:00","dateUpdated":"2021-09-09T16:01:35+00:00","dateLastComment":"2021-09-09T15:49:43+00:00","insertUserID":139729,"insertUser":{"userID":139729,"name":"Javier Ortiz","url":"https:\/\/community.smartsheet.com\/profile\/Javier%20Ortiz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-04T18:10:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":139729,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-11T19:12:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":676,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/82952\/how-to-create-a-master-schedule-sheet-in-project-prog-schedule-mode-by-linking-other-schedule-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/82952\/how-to-create-a-master-schedule-sheet-in-project-prog-schedule-mode-by-linking-other-schedule-sheets","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-09-14T19:04:35+00:00","dateAnswered":"2021-09-09T15:49:43+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

I need to use an IF / THEN formula to compare a cell from one column to a cell in another column
I could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY DATE is within SEVEN (7) DAYS of the START DATE, the LIGHT is RED. Can the DELIVERY…
Time Tracking
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
Is there a formula/function to help count number of children assigned to specific parent tasks?
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respective Health Status (Green, Yellow, Red). I am aware that I can apply a "COUNTIF" formula and set the range to encompass the…
Start and end date line chart
嗨,团队,谁能help me how can I create a line chart based on below information. I
Dependency Logic based on one or the other predecessor tasks
Is is possible to create schedule logic where a dependent task is dependent on one of two predecessors (either or not both)? For Example: I am trying to build out a schedule template for if a permit is required vs not for a specific project. IF a permit is required then the rest of the schedule should be based on the…
Gnatt chart Bar formatting - grid missing
H Folks, For some reason I have areas in my smartsheet plan that have grid missing, some are ok. Does anyone have an idea how I can correct this and add the gridelines back please. thanks Mark,
Contact not displaying name on Assigned To field
When I try to add one particular contact that I added to my contacts list to the Assigned To field on a Gantt chart, it won't display the Name... just the person's full email address. This is only happening for this one contact - the rest are fine. I did some troubleshooting and if I edit the email address with a dummy…
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets
Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…

Gantt View

Discussion List