Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Running Multiple Projects on SS

Regan French
edited 12/09/19 inArchived 2016 Posts

嘿,党卫军社区,

我参与一个公司,目前还没有central data base overviewing all projects.

I want to put a system in place where the PMs can manage their own projects.

Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle.

I understand that Smartsheet is a brilliant program for this.

If anyone has worked with similar Smartsheets before, I would appreciate their feedback on how they did it successfully giving their company that edge on project communication, project integration, scope management, schedule management, etc...

Any comment will be helpful.

Thanks a lot guys.Smile

Regan French

Comments

  • Hello Regan—if you don't find the answer you're looking for in the community, you might seek out our Design Desk team to help create the workflow you need://www.santa-greenland.com/design-desk

  • I hope others will also respond and share their ideas, but I'll explain a common use case that I've heard from customers who are using our newSmartsheet for Salesforce integrationto keep their Sales and Finance team members informed of the latest project status in Smartsheet...


    Many customers have their Salesforce instance configured with custom Project and Milestone objects that are affiliated with an Opportunity or an Account. The Project Manager collaborates with the project team to execute the project inside Smartsheet, where typically there is a more detailed set of tasks under each milestone. As Milestone status or dates change, the Project Manager update the corresponding Milestones in Salesforce to keep the Sales team informed.


    The benefit is that the Sales and Finance teams see the latest status of a project and its milestones while looking at an Account or Opportunity directly inside Salesforce. The challenge customers described to us is that Project Managers must remember to login to Salesforce and manually update the the date and status of a Milestones as they change in the project schedule in Smartsheet. They often forget or do it only once per week and the project status information in Salesforce becomes out of date or inaccurate.


    Automating this scenario is one of use cases we designed the Smartsheet for Salesforce integration around. With the new Smartsheet for Salesforce integration, the status and dates of Milestones in Salesforce are automatically kept in sync with the schedule in Smartsheet as the Project Manager and Project Team update the schedule. The Project Manager and the Project Team no longer have to manually update Salesforce, saving their time, and the Sales and Finance teams are always informed with accurate and current project/milestone information inside Salesforce.


    Hope this is helpful. I'm looking forward to other customers sharing how they communicate Project Status with sales, quoting and other teams.



    Scott Willeke | Smartsheet
    Sr. Product Manager, Strategic Integrations

This discussion has been closed.
Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":106216,"type":"question","name":"\"Invalid Data Type\" Error - Need Formula Help!","excerpt":"I am trying to add 3 years from the \"Date Completed\" column; however, I'm getting the \"INVALID DATA TYPE\" for the cells where \"Date Completed\" are blank. I'd like for the \"Date of Renewal\" to stay blank if the Date Completed is blank. =DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date…","categoryID":322,"dateInserted":"2023-06-08T17:15:09+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T17:25:27+00:00","insertUserID":122093,"insertUser":{"userID":122093,"name":"Ashley Pierce","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Pierce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2NKMA31TW5J8\/nPAIF3JG5VC5S.jpg","dateLastActive":"2023-06-08T18:25:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":122093,"lastUser":{"userID":122093,"name":"Ashley Pierce","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Pierce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2NKMA31TW5J8\/nPAIF3JG5VC5S.jpg","dateLastActive":"2023-06-08T18:25:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3372492036,"url":"https:\/\/community.smartsheet.com\/discussion\/106216\/invalid-data-type-error-need-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106216\/invalid-data-type-error-need-formula-help","format":"Rich","tagIDs":[219,254,324,485],"lastPost":{"discussionID":106216,"commentID":379670,"name":"Re: \"Invalid Data Type\" Error - Need Formula Help!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379670#Comment_379670","dateInserted":"2023-06-08T17:25:27+00:00","insertUserID":122093,"insertUser":{"userID":122093,"name":"Ashley Pierce","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Pierce","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2NKMA31TW5J8\/nPAIF3JG5VC5S.jpg","dateLastActive":"2023-06-08T18:25:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T17:25:08+00:00","dateAnswered":"2023-06-08T17:23:54+00:00","acceptedAnswers":[{"commentID":379668,"body":"

Add an IFERROR<\/p>

=IFERROR(DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row)), \"\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":485,"urlcode":"community-champions","name":"Community Champions"}]},{"discussionID":106206,"type":"question","name":"Pie Chart breaks when values are zero","excerpt":"In a dashboard, pie charts are breaks the reference and shows as Unable to display chart when reference values are changed to zero as these vales calculated via formula. Only Bar charts are showing as No data to display. My end goal is to show as No data to display when values are zero. Kindly help me out here.","categoryID":322,"dateInserted":"2023-06-08T15:21:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T18:01:33+00:00","insertUserID":162199,"insertUser":{"userID":162199,"name":"Gajapathi R M","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Gajapathi%20R%20M","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T17:37:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-08T18:05:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":24,"score":null,"hot":3372488578,"url":"https:\/\/community.smartsheet.com\/discussion\/106206\/pie-chart-breaks-when-values-are-zero","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106206\/pie-chart-breaks-when-values-are-zero","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106206,"commentID":379679,"name":"Re: Pie Chart breaks when values are zero","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379679#Comment_379679","dateInserted":"2023-06-08T18:01:33+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-08T18:05:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7KSJLJBZG3GE\/only-bar-chart-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Only Bar Chart.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T17:37:29+00:00","dateAnswered":"2023-06-08T17:12:16+00:00","acceptedAnswers":[{"commentID":379665,"body":"

So is it a sheet that has the calculations on it or a row report? If it is a sheet then you can add 0.00001 to all calculations and decrease the shown decimals. This will maintain some data greater than zero but only display zero.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts