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.
Tracking Purchasing Approval
We are trying to find a way to track our purchasing process. I have created a sheet with a web form, but am having trouble with the approvals part of our process. Typically the purchaser would fill out the web form to request payment to a vendor or to themselves as reimbursement, then they need to get 2 approvals from management. Is there a way to send the completed web form to someone and give them the ability to approve it without going into my sheet? I have played with merging the sheet data into a goodle doc and sending it to them, but can't find a way to incorporate the approval into the flow. I would like the sheet to reflect that the expense is approved, so that I can look at the sheet an know when something is approved by all parties. Does anyone else use Smartsheets for this type of process?
Comments
-
Atus Bartal ✭✭✭✭✭✭
Dear Julie,
Unfortunately there's no way to send a completed web form to someone else. However, you can create 2 reports to the 2 manager where they can approve the requests (while seeing only the new - non-approved - items). I suggest to read Jeremy Michels'sdescriptionof their workflow, it can give you some ideas. If you don't get ahead, I can give you a simple example on what to try.
Atus
-
Atus Bartal ✭✭✭✭✭✭
I have searched in previous posts, and I've found more discussions to read. You may get the answer from Craig's great solutions in this one:https://community.smartsheet.com/discussion/use-triggers-smartsheet
-
JohnHinkle ✭✭✭✭✭✭
Use update requests! You can send the row to anyone (Smartsheet user or not) and the recipient can view and edit the row in form view. Changes made to the form are immediately reflected in the sheet.
http://help.smartsheet.com/customer/en/portal/articles/504779-using-update-requests
-
Hi Julie,
也许会有一个解决方案在Zapier强度rgration...
Zapier will send an email to somone when a new recrd is added to a list.....
You complete the Subject and Message using fields from the New row of Data.
The user could then return the email to Zapier with a "Approve" or "Reject" in a certain place. Zapier might then be able to decipher the email contect (Approve or reject) and add it back into smartsheet....
I use the word "might", as it will depend upon how structured you can make the email template and the user/approvers ability to put the approval into the right spot.
Hey, its worth a look.....
P.S. I use Zapier to email out, I have only tested the Return path.
-
J. Craig Williams ✭✭✭✭✭✭
Julie,
Did you get what you needed?
Atus,
Thanks for the compliment.
Craig
Categories
Try this:<\/p>
=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/4268/\", 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":106250,"type":"question","name":"Group & User Management - Sorting of Members","excerpt":"Hi I have 2 questions regarding Group Management... Does anyone know if it's possible to sort the Members alphabetically please? Even though they were imported in alphabetical order, when I open the group the list is randomly sorted. Not helpful when you're trying to search for a user within a list of 100 people. Is there…","categoryID":321,"dateInserted":"2023-06-09T05:36:26+00:00","dateUpdated":"2023-06-09T07:56:35+00:00","dateLastComment":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162237,"lastUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372605217,"url":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106250,"commentID":379805,"name":"Re: Group & User Management - Sorting of Members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379805#Comment_379805","dateInserted":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T12:50:00+00:00","dateAnswered":"2023-06-09T11:29:41+00:00","acceptedAnswers":[{"commentID":379791,"body":"