Human Resources Time Off Requests with Functionality
Hi,
I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out.
First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate employee.
I can do the first and second and can't figure out the third.
Any help is greatly appreciated!
Thanks!
Comments
-
Shaine Greenwood EmployeeHello,
We wrote a blog post on how you can use resource management to help you with vacation time://www.santa-greenland.com/blog/support-tip-manage-vacation-schedules-resource-management
If you're looking for a different way to track time off, can you elaborate on how you'd like this to be tallied?
Help Article Resources
Categories
Try this:<\/p>
=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/17426/\", IF(TODAY() > [Date of Site Survey (Product)]@row, \"yes\", \"no\"))<\/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":[]},{"discussionID":106277,"type":"question","name":"Help creating formula to update inventory automatically","excerpt":"The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…","categoryID":322,"dateInserted":"2023-06-09T16:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":37,"score":null,"hot":3372664184,"url":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106277\/help-creating-formula-to-update-inventory-automatically","format":"Rich","tagIDs":[204,219,254],"lastPost":{"discussionID":106277,"commentID":379911,"name":"Re: Help creating formula to update inventory automatically","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379911#Comment_379911","dateInserted":"2023-06-09T18:12:07+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+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\/FMANSEYA9OS3\/mm-brochures-request-sheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MM-Brochures-Request-Sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T18:11:32+00:00","dateAnswered":"2023-06-09T17:51:51+00:00","acceptedAnswers":[{"commentID":379899,"body":"
