How to use Smartsheet's legacy resource management function to highlight conflicts and auto change
Hello, apologies in advance if this appears to be a rather basic enquiry, however, I'm not familiar with Smartsheet's legacy resource mangagement tool.
I've had an enquiry from a colleague who has a Gantt chart sheet showing his team's tasks (as below). He's wanting the sheet to be able to add holidays for people and for the system to either highlight conflicts or change dates or both.
An example is, Kim Cassels will be on holiday Friday 22 July and 1-5 Aug. How can he get it to show how it impacts his plan? He's hoping that the sheet will highlight conflicts and/or to auto change the dates accordingly based upon stretched resource.
I've checked and he does have the resource viewer setting ticked in the System Admin settings.
Any advice/pointers you can offer would be much appreciated
Answers
-
SteCoxy ✭✭✭✭✭
One thing I noticed when my colleague shared his sheet was that there didn't appear to be the dependencies/project settings appearing in the top right corner, however, the critical path icon was. I'm not sure if this might have a bearing on things?
-
Genevieve P. Employee Admin
Hi@SteCoxy
In Legacy Resource Management, if you assign that resource (e.g. Kim) to a row for the holiday duration as 100%, then this should make a red icon in the shape of a person appear to the left of any rows that make that resource over-allocated (indicating they're scheduled to work during a time where they're on holiday).
Here's the documentation with some screen captures that include this red icon:Track and allocate resources
This won't automatically change anything for you, but it will make it easy to visually identify if a resource is over allocated across sheets/projects.
Cheers,
Genevieve
-
SteCoxy ✭✭✭✭✭
Thank you Genevieve - much appreciated :-)
Categories
<\/p>
You can just include a blurb that says that they are acknowledging by submitting within the Approval automation.<\/p>
<\/p>
You can set up an update request automation as a reminder that they need to enter their initials if they submit but didn't the first time.<\/p>
<\/p>
The last option I can think of that would truly make it required is a bit complex but possible. The first step is to create an \"approval sheet\". This sheet will have the same fields in it that you need to send in the approval request and a form created to match.<\/p>
<\/p>
You would then take the base form URL and drop it into a formula on the original sheet that allows you to basically generate a custom form on each row that will have the row data prefilled when someone clicks on the URL in that row. Since you can make form fields required, this will give you the ability to require their acknowledgement prior to them submitting their approval.<\/p>
<\/p>
Send this custom form URL through an alert and instruct the users to click the link to open the approval form.<\/p>
<\/p>
The form entry would populate the \"approval sheet\", but you can use formulas with cross sheet references to pull the appropriate data back over to your original sheet.<\/p>
<\/p>
If that last option sounds like something you would be interested in, fell free to let me know, and I will try to pull together a few links to help you get started building the formula.<\/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":[{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}]},{"discussionID":108166,"type":"question","name":"Synchronization of Smart sheet and Outlook Calendar","excerpt":"I am trying to synchronize an appointment list created with Smart sheet with Outlook Calendar. I was able to get the date to reflect in Outlook Calendar, but is there any way to get the time and the content of the appointments on the Smart sheet to reflect in Outlook Calendar?","snippet":"I am trying to synchronize an appointment list created with Smart sheet with Outlook Calendar. I was able to get the date to reflect in Outlook Calendar, but is there any way to…","categoryID":321,"dateInserted":"2023-07-27T07:37:41+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T21:04:37+00:00","insertUserID":144305,"insertUser":{"userID":144305,"name":"Kenji","url":"https:\/\/community.smartsheet.com\/profile\/Kenji","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A2lcx_I5Ojw!m8kqn54NZSs!obOvPtLS1JT","dateLastActive":"2023-07-27T21:02:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":144305,"lastUser":{"userID":144305,"name":"Kenji","url":"https:\/\/community.smartsheet.com\/profile\/Kenji","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A2lcx_I5Ojw!m8kqn54NZSs!obOvPtLS1JT","dateLastActive":"2023-07-27T21:02:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":3380936538,"url":"https:\/\/community.smartsheet.com\/discussion\/108166\/synchronization-of-smart-sheet-and-outlook-calendar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108166\/synchronization-of-smart-sheet-and-outlook-calendar","format":"Rich","lastPost":{"discussionID":108166,"commentID":387682,"name":"Re: Synchronization of Smart sheet and Outlook Calendar","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387682#Comment_387682","dateInserted":"2023-07-27T21:04:37+00:00","insertUserID":144305,"insertUser":{"userID":144305,"name":"Kenji","url":"https:\/\/community.smartsheet.com\/profile\/Kenji","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A2lcx_I5Ojw!m8kqn54NZSs!obOvPtLS1JT","dateLastActive":"2023-07-27T21:02:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9CM5AMI8BDNA\/02.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"02.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T21:02:03+00:00","dateAnswered":"2023-07-27T08:24:09+00:00","acceptedAnswers":[{"commentID":387453,"body":"
Hi @Kenji<\/a> <\/p> I hope you're well and safe!<\/p> Unfortunately, it's not possible now, but it's an excellent idea!<\/p> Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> Here's a possible workaround or workarounds <\/strong><\/p> Would any of those options work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":108163,"type":"question","name":"Can we use IFERROR and ISBLANK in the same formula together?","excerpt":"I want help for the following formula: I want to divide two columns based on UniqueWorkstream column if it has any value. If the workstream column is blank, it should not show any value. For that I have used the formula: =I=IF(ISBLANK(UniqueWorkstream@row), \" \", [Count of Tasks Overdue(Schedule)]@row \/ [Total…","snippet":"I want help for the following formula: I want to divide two columns based on UniqueWorkstream column if it has any value. If the workstream column is blank, it should not show any…","categoryID":321,"dateInserted":"2023-07-27T06:30:22+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T12:23:16+00:00","insertUserID":162321,"insertUser":{"userID":162321,"name":"sweta22","title":"Sweta Patnaik","url":"https:\/\/community.smartsheet.com\/profile\/sweta22","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T14:33:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"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-27T12:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3380901818,"url":"https:\/\/community.smartsheet.com\/discussion\/108163\/can-we-use-iferror-and-isblank-in-the-same-formula-together","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108163\/can-we-use-iferror-and-isblank-in-the-same-formula-together","format":"Rich","lastPost":{"discussionID":108163,"commentID":387493,"name":"Re: Can we use IFERROR and ISBLANK in the same formula together?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387493#Comment_387493","dateInserted":"2023-07-27T12:23:16+00:00","insertUserID":8888,"insertUser":{"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-27T12:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TLJ96BBODZEA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T11:46:18+00:00","dateAnswered":"2023-07-27T07:49:05+00:00","acceptedAnswers":[{"commentID":387451,"body":" Hi @sweta22<\/a> <\/p> I hope you're well and safe!<\/p> Try something like this.<\/p> =IF(UniqueWorkstream@row <> \"//www.santa-greenland.com/community/discussion/93115/\", IFERROR([Count of Tasks Overdue(Schedule)]@row \/ [Total Tasks(Schedule)]@row, \"//www.santa-greenland.com/community/discussion/93115/\"))<\/p> Did that work\/help? <\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4887,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">