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

Julie Murphy
edited 12/09/19 inArchived 2016 Posts

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

This discussion has been closed.
[Date of Site Survey (Product)]@row, \"yes\", \" \")) Intended logic\/result - If date cell is blank, then \"blank\" (this worked when I tried without the 2nd argument added) If date is in…","categoryID":322,"dateInserted":"2023-06-09T14:00:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162220,"lastUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":15,"score":null,"hot":3372641415,"url":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","format":"Rich","lastPost":{"discussionID":106265,"commentID":379837,"name":"Re: If Date is blank + past formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379837#Comment_379837","dateInserted":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:43:14+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:28:35+00:00","dateAnswered":"2023-06-09T14:12:11+00:00","acceptedAnswers":[{"commentID":379830,"body":"

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":"

HI @L Darvesh<\/a> <\/p>

  1. Currently there is no sorting inside of a group. Please vote for that functionality in this Enhancement Request:<\/li><\/ol>
    \n \n https:\/\/community.smartsheet.com\/discussion\/104139\/group-management-sorting-contact-list-alphabetically\n <\/a>\n<\/div>\n
    1. To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106239,"type":"question","name":"Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","excerpt":"I spent the last month building a solution for people to sign up for mentors by creating a sheet that has information about each mentor and lots of formulas color fields where someone has already signed up with only a max number of sign up fields (aka I can't do this in forms that I know of). I created a Dynamic View with…","categoryID":343,"dateInserted":"2023-06-08T20:54:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3372578665,"url":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","format":"Rich","tagIDs":[223,443],"lastPost":{"discussionID":106239,"commentID":379829,"name":"Re: Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379829#Comment_379829","dateInserted":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:07:07+00:00","dateAnswered":"2023-06-08T23:09:15+00:00","acceptedAnswers":[{"commentID":379755,"body":"
      \n \n https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login\n <\/a>\n<\/div>\n

      Hi Sara!<\/p>

      Dynamic View has its own settings for sharing that are separate from those on your underlying published sheet. If you haven't already shared the DV, itself (as well as the source sheet<\/em>), I think that may be the roadblock here. <\/p>

      When you open the settings for your DV, you'll see \"Sharing<\/strong>\" on the far right. I chose the Shared domains option at the bottom to ensure users enterprise-wide could access a particular DV I created, even if they didn't have a Smartsheet account. Adding the appropriate domain(s) (i.e., the part of your email address after the @<\/strong>; like CompanyXYZ<\/em>.com<\/em>) for your user audience should clear up the restrictions requiring sign-in.<\/p>

      If sharing at the domain level is too broad, I would suggest creating a named Group within the Smartsheet Admin Center (\"Group Management<\/em>\"). You can copy a list of email addresses and paste them into the \"Add Members\" field to \"bulk load\" a large group of users. Once your group is created, use the dropdown in the Shared groups option to select the appropriate group.<\/p>

      \n
      \n \n \"DV<\/img><\/a>\n <\/div>\n<\/div>\n

      I hope this helps resolve your problem! Please let me know how it goes!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":223,"urlcode":"Publish","name":"Publish"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

      Trending Posts