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.
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
Comments
-
JamesR ✭✭✭✭✭✭Create a Report accross all projects, using Resources "Fred Smith" add start, finish and duration columns.
James
-
Thanks James. however this is not quite what I was looking for. I'm looking for more of somethign that resembles a time card. By this I mean a breakdown of hours planned to be wrok by each employee weekly. I've started some of this and the formulas get a little crazy. For example. if a duration spans across more than one month the process to extract the number of hours per month (let alone per week) gets cumbersome.
-
Gordon ✭✭✭✭✭
I'm interested in something similar. I was under the impression that SS was going to add the ability to show resource management in hours instead of % in the latest release, but that was not the case. I still need to figure out a way to have a consolidated schedule in GANTT format across all my projects with the hours shown instead of %.
-
Travis EmployeeGordon, in our release tonight, we are adding the ability to view Gantt charts in reports. You can use reports to consolidate a user's schedule from all your projects and view a Gantt chart with that information.
Categories
You didn't specify how you are getting an email address in that cell, but here's some ideas.<\/p>
There's a couple ways to go about it. A lookup function based on some criteria to select who to send it to. Possibly adding a option to select who to email within the form. Manually entering an email. A couple options through automations would be to specify who to send it to or input a constant email address by using the change cell value.<\/p>
The column type has to be a Contact List too.<\/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":107845,"type":"question","name":"Smartsheet Form","excerpt":"Hi all, I've set up a new smartsheet with a form, the form isnt populating the sheet. The data is not appearing at the end of the rows, there is not conditional formatting to cause any 'invisible' data. The settings (screenshot attached) all seem fine. Any suggestions?","snippet":"Hi all, I've set up a new smartsheet with a form, the form isnt populating the sheet. The data is not appearing at the end of the rows, there is not conditional formatting to…","categoryID":321,"dateInserted":"2023-07-20T11:36:13+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T12:29:32+00:00","insertUserID":148086,"insertUser":{"userID":148086,"name":"Lisa B 2022","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20B%202022","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbls3ea1kMuE-s37Yj-hmWMgVFXC1jOGRq6oYZd=s96-c","dateLastActive":"2023-07-20T11:44:04+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-20T15:49:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":28,"score":null,"hot":3379712145,"url":"https:\/\/community.smartsheet.com\/discussion\/107845\/smartsheet-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107845\/smartsheet-form","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":107845,"commentID":386129,"name":"Re: Smartsheet Form","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386129#Comment_386129","dateInserted":"2023-07-20T12:29:32+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-20T15:49:02+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T11:45:03+00:00","dateAnswered":"2023-07-20T11:43:24+00:00","acceptedAnswers":[{"commentID":386113,"body":"
Hi @Lisa B 2022<\/a> <\/p> I hope you're well and safe!<\/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":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":107831,"type":"question","name":"How to only edit a cell if it is negative","excerpt":"I have a formula that sometimes will pull a negative number. What would the formula be to multiply by -1 if negative?","snippet":"I have a formula that sometimes will pull a negative number. What would the formula be to multiply by -1 if negative?","categoryID":322,"dateInserted":"2023-07-20T01:52:32+00:00","dateUpdated":"2023-07-20T02:06:37+00:00","dateLastComment":"2023-07-20T11:52:39+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":162138,"lastUserID":162138,"lastUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3379673111,"url":"https:\/\/community.smartsheet.com\/discussion\/107831\/how-to-only-edit-a-cell-if-it-is-negative","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107831\/how-to-only-edit-a-cell-if-it-is-negative","format":"Rich","lastPost":{"discussionID":107831,"commentID":386120,"name":"Re: How to only edit a cell if it is negative","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386120#Comment_386120","dateInserted":"2023-07-20T11:52:39+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+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":"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\/N6K1YLWHGSYF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T11:52:23+00:00","dateAnswered":"2023-07-20T03:38:20+00:00","acceptedAnswers":[{"commentID":386101,"body":" You can just wrap the entire formula you are using in ABS() to return the absolute value.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
