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.
I was thinking of setting up aPOS/point of salesheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc..
Then it came to mind that I should check here.
I did speak with tech support and they directed me to a template names "Inventory Management."
It is very close to the idea what I could use. But I think I need to add a few things. My only question is how.
What I would like it to have is a sales colunm. If you do a google search on How to set up pos in excel yu'll see instruction on wikihow.com
What I'd like it to do, is minus the item, and fill the profit colum and update the inventory colum etc..
I also would like to see if I could create a barcode from Item Number and scan a lable on the item.
But I'm not the only one that says its to vage,
So, If anyone has any ideas?
or has set up a POS with smartsheet. I'd really appriciate your input.
To access and read the bar-code, you are going to need to integrate to a third party application. I'd start with AppSheet (since that is in my toolbox) but there are likely other possibilties.
I work with Richard Rymill at Smarter Business Processes ([email protected]) who provides free initial consulting if you are thinking of going that route.
I work with Richard Rymill at Smarter Business Processes ([email protected]) who provides free initial consulting if you are thinking of going that route.
Sorry if that was not clear.
Smart has similar formulas in many cases, but is not a one-to-one match.
I keep this article bookmarked for the references at the bottom:
Ok, how about using a helper column with a 0 or 1 being input by your automation, and then use this as the trigger. So set the default on the column to 0, and if an attachment is there, leave it at 0. Then if an attachment is not there workflow will set it to 1, and that would trigger the automated workflow to run.<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":108318,"type":"question","name":"Count to show the High Priority Items","excerpt":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","snippet":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","categoryID":322,"dateInserted":"2023-07-31T18:51:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":121230,"lastUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":26,"score":null,"hot":3381664822,"url":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","format":"Rich","lastPost":{"discussionID":108318,"commentID":388103,"name":"Re: Count to show the High Priority Items","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388103#Comment_388103","dateInserted":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+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\/382QSC10NTUW\/count-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"count.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T19:48:14+00:00","dateAnswered":"2023-07-31T19:18:51+00:00","acceptedAnswers":[{"commentID":388092,"body":"
J. Craig Williams ✭✭✭✭✭✭
