❓️Product questions
Sign in andask it here!The community's got your back.

Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.

Share your knowledge!
Help others byanswering questions.

Resource Management

Ask your questions about Resource Management by Smartsheet or about the Resource Management panel.

Discussion List

@Guang<\/a> <\/p>

Yes, if you enable dependencies.<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors\n <\/a>\n<\/div>

You do have an option of disenabling the dependencies function; then, you can have formulas to calculate duration, etc. But that removes most of the Smartsheet's charm, like automatic start and finish date adjustment.<\/p>

Changing the duration based on the assignees is a tricky business. Some assignees spend 20 or 50% of their time, while others spend 100%.<\/p>

 I know very little about OmniPlan, but it looks similar to the Smartsheet of MS Project. If you can access a Smartsheet account, why don't you play with various functions and formulas to find one that satisfies your needs?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":355,"name":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management","allowedDiscussionTypes":["discussion","question"]},"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":109108,"type":"question","name":"Reminders: How to set up reminder if cell DOESN'T change?","excerpt":"I want to set up reminders, and force and escalation, if a Status cell does not change after X days. Scenario: Someone fills out an intake form. The Status is \"Not Started\" by default at the time the Intake form is submitted. The team's SLA is 3 days to change the status to \"Reviewed\" or \"In Progress.\" If they don't, I…","snippet":"I want to set up reminders, and force and escalation, if a Status cell does not change after X days. Scenario: Someone fills out an intake form. The Status is \"Not Started\" by…","categoryID":355,"dateInserted":"2023-08-17T16:49:18+00:00","dateUpdated":null,"dateLastComment":"2023-08-17T17:50:34+00:00","insertUserID":161934,"insertUser":{"userID":161934,"name":"Cash","title":"Marketing Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Cash","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jINkY7fMyro!!rD3jgF2oi8v","dateLastActive":"2023-08-22T21:53:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161934,"lastUser":{"userID":161934,"name":"Cash","title":"Marketing Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Cash","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jINkY7fMyro!!rD3jgF2oi8v","dateLastActive":"2023-08-22T21:53:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":125,"score":null,"hot":3384586792,"url":"https:\/\/community.smartsheet.com\/discussion\/109108\/reminders-how-to-set-up-reminder-if-cell-doesnt-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109108\/reminders-how-to-set-up-reminder-if-cell-doesnt-change","format":"Rich","lastPost":{"discussionID":109108,"commentID":391222,"name":"Re: Reminders: How to set up reminder if cell DOESN'T change?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/391222#Comment_391222","dateInserted":"2023-08-17T17:50:34+00:00","insertUserID":161934,"insertUser":{"userID":161934,"name":"Cash","title":"Marketing Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Cash","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jINkY7fMyro!!rD3jgF2oi8v","dateLastActive":"2023-08-22T21:53:54+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":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-17T17:50:08+00:00","dateAnswered":"2023-08-17T17:27:08+00:00","acceptedAnswers":[{"commentID":391212,"body":"

@Cash<\/a> <\/p>

Create a field that checks if both the created date is more then 3 days ago and the status is \"Not Started\". Then have an automation run every morning that is filtered to this field being checked.<\/p>

Example formula:<\/p>

=IF(AND(Status@row=\"Not Started\",(TODAY()-[Created Date]@row)>3),1,0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":355,"name":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management","allowedDiscussionTypes":["discussion","question"]},"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":108074,"type":"question","name":"Stop people from tracking to a project when an hours or fee budget is exhausted","excerpt":"Hi Community! Does anyone know if there is a way to set up a project in Resource Management so when the time or fee budget is exhausted, people can no longer track time to that project? The only lock setting I am able to see if one to lock time entries to the project once added (or after 14 days). Not sure if I am just…","snippet":"Hi Community! Does anyone know if there is a way to set up a project in Resource Management so when the time or fee budget is exhausted, people can no longer track time to that…","categoryID":355,"dateInserted":"2023-07-25T23:15:36+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T23:41:37+00:00","insertUserID":163801,"insertUser":{"userID":163801,"name":"beverlyjosie","title":"Governance and Operations Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/beverlyjosie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T18:14:14+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-09-21T07:49:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":183,"score":null,"hot":3380831233,"url":"https:\/\/community.smartsheet.com\/discussion\/108074\/stop-people-from-tracking-to-a-project-when-an-hours-or-fee-budget-is-exhausted","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108074\/stop-people-from-tracking-to-a-project-when-an-hours-or-fee-budget-is-exhausted","format":"Rich","tagIDs":[468],"lastPost":{"discussionID":108074,"commentID":387700,"name":"Re: Stop people from tracking to a project when an hours or fee budget is exhausted","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387700#Comment_387700","dateInserted":"2023-07-27T23:41:37+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-09-21T07:49:33+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":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-26T16:36:54+00:00","dateAnswered":"2023-07-26T16:13:19+00:00","acceptedAnswers":[{"commentID":387210,"body":"

Hi @beverlyjosie<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, as far as I know, 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>

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":355,"name":"Resource Management","url":"https:\/\/community.smartsheet.com\/categories\/resource-management","allowedDiscussionTypes":["discussion","question"]},"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":468,"urlcode":"resource-management","name":"Resource Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=355&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&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":4,"limit":3},"title":"Trending in Resource Management","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Resource Management