装配+库存跟踪
我创建了一个智能表来跟踪我们某一特定产品线的每一个销售单位。ob欧宝娱乐app手机下载
该表格包括设备的序列号、型号、客户名称、客户订单号、内部“项目号”、设备的当前位置(例如:“在订单上”、“约翰尼的工作台”、“软件部门”、“仓库”、“发货途中”、“最终用户”),以及用于产品选项和其他各种信息的许多其他列。ob欧宝娱乐app手机下载
我希望能够让公司里的每个人都有一种方式来扫描或搜索单元的序列号,并立即调出该特定单元的所有内容,并且能够更改每个单元的位置以及输入其他可用的信息。虽然我显然希望尽可能走便宜/免费路线,但我对任何第三方SaaS或PC或移动应用程序都持开放态度。
我们总是匆匆忙忙地把事情做完,然后出门。不幸的是,尝试让每个人都登录到smartsheet,导航到生产跟踪表,找到单元的行,然后导航到他们需要更新的数据列,这比它应该ob欧宝娱乐app手机下载更具挑战性。
的梦想:
如果“Bob”正在使用序列号为34584n7d3的设备,他可以扫描序列号条形码或搜索“n7d3”,立即被带到一个显示所有相关信息的页面,将位置更新为“Bob的办公桌”,然后继续工作,继续生产过程。ob欧宝娱乐app手机下载
有人有什么好主意吗,我是在浪费时间吗?
评论
-
Shaine格林伍德 员工
嗨,约翰,
虽然人们必须登录Smartsheet,但你可以让每个人都使用Smartsheet搜索来找到他们需要的行。(Shift + Ctrl + F)
人们可以打开搜索窗口,输入n7d3,带有序列号的表格就会出现。他们甚至可以通过单击搜索结果或单击右侧的edit row图标来快速编辑行。
如果这不起作用,您可以通过appsheet或zapier等服务寻求第三方集成,看看他们是否可以完成此任务。
-
布莱恩·哈塞特 ✭✭✭
嗨,约翰,
我正在做的事情非常类似于你正在寻找,并发现,实现这一目标的唯一途径没有外部应用程序如下:
如果“鲍勃”在平板电脑或手机上使用智能表格应用程序,他只需搜索条形码即可。[或者在你的情况下,如果他输入*n7d3来查找部分代码]。通过点击搜索结果,它将把他直接带到编辑模式下的智能表行,这样他就可以在单元格中编辑与他相关的下拉框,然后保存。
如果工作表中的数据太多,您可以为Bob定制一个报告,使用与他需要看到的内容相关的更少的列。
我很想知道你们是否找到了替代方案。
类别
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to \"override\" In Progress, you would need to adjust the order in which your IFs are nested.<\/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":106419,"type":"question","name":"SUMIFS not working (referencing another sheet)","excerpt":"I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet. So on my sheet with the function, I have it as: =SUMIFS({Total GL Detail Range 4}, {Total GL Detail Range 5}, Project8, {Total GL Detail Range 3}, Title@row) ...where the \"Total GL Detail\" is the other sheet referenced. Range…","categoryID":322,"dateInserted":"2023-06-14T13:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:49:20+00:00","insertUserID":162357,"insertUser":{"userID":162357,"name":"EBooher","url":"https:\/\/community.smartsheet.com\/profile\/EBooher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:58:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T01:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":103,"score":null,"hot":3373533417,"url":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","format":"Rich","lastPost":{"discussionID":106419,"commentID":380651,"name":"Re: SUMIFS not working (referencing another sheet)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380651#Comment_380651","dateInserted":"2023-06-14T20:49:20+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T01:08:28+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-14T20:08:57+00:00","dateAnswered":"2023-06-14T18:51:01+00:00","acceptedAnswers":[{"commentID":380616,"body":"
Ok. I just had someone else earlier this week have the same issue. Even after converting all of the IDs to text it still wasn't working. Lets try converting everything on the source sheet to numbers. Take that LEFT formula you have that strips the ID out and wrap it in a VALUE function.<\/p>
=VALUE(LEFT(.......................))<\/p>
<\/p>
Then try the COUNTIFS on the ID again, but instead of referencing the helper cell in the formula sheet that we created, reference the linked cell that houses the numerical 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":[]}">