新来的，一般问题

Kimbersh
Kimbersh ✭
在内容基本知识

你好，你必须自己写所有的函数吗?还是有工具来帮助这个过程?我需要做一个xlookup索引和匹配更新到另一个表。我习惯使用ablebits工具。

当我在这里，它是有可能上传到一个文件覆盖(更新)当前工作表上的数据?

我可以同步两张表，这样当一个更新时，两个都会更新吗?

我在哪里可以找到我可以使用的应用程序列表，如果有的话?

谢谢你！

金

标签:
· 在Facebook上分享 在Twitter上分享

答案

类别

Hello,<\/p>

Try this...<\/p>

You will need to add an Auto Number column to your sheet to count incoming responses and make sure you capture your dealers' emails in a defined contacts field. Add a checkbox field for \"Responded\" too. Obviously you don't want to include this on the form.<\/p>

You can then set up an Automation to run when new rows are added and any field changes with a filter condition that sends a 'You're in!\" message (aka \"Alert someone.....\") to the email in the contact field where the Auto Number is less than 100 and another one for \"Sorry we're full\" where the Auto Number is greater than 100.<\/p>

Add a second step to your Automations to change the cell value in the \"Responded\" field to checked when the Automations runs on newly added rows.<\/p>

Add a second filter so that the Automations only run on rows where \"Responded\" is unchecked. That way you won't end up messaging all your dealers every time a new response arrives on the form.<\/p>

Jim<\/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":[]},{"discussionID":102749,"type":"question","name":"Data Shuttle Mapping Columns Error","excerpt":"Hello! I am new to Data Shuttle, I've gotten to flow perfectly once, and I decided to test it again and write down the steps and now I'm getting an error that says \"Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns.\" However, all of my columns in…","categoryID":343,"dateInserted":"2023-03-16T16:05:51+00:00","dateUpdated":null,"dateLastComment":"2023-03-16T20:07:15+00:00","insertUserID":159497,"insertUser":{"userID":159497,"name":"Heather572","url":"https:\/\/community.smartsheet.com\/profile\/Heather572","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3UlTfyDICLs!Zfjc2Yo8cLc!JmZxXOGa4WF","dateLastActive":"2023-03-17T12:01:11+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-03-17T17:39:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3357981786,"url":"https:\/\/community.smartsheet.com\/discussion\/102749\/data-shuttle-mapping-columns-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102749\/data-shuttle-mapping-columns-error","format":"Rich","lastPost":{"discussionID":102749,"commentID":367644,"name":"Re: Data Shuttle Mapping Columns Error","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/367644#Comment_367644","dateInserted":"2023-03-16T20:07:15+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-03-17T17:39:32+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-03-16T18:40:10+00:00","dateAnswered":"2023-03-16T18:29:25+00:00","acceptedAnswers":[{"commentID":367616,"body":"

Have you edited the workflow and checked the mapping step to make sure nothing is changed there?<\/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":[]},{"discussionID":102727,"type":"question","name":"INDEX\/MATCH on Blank and No Matches","excerpt":"Hi all, Working on using Index\/Match to pull through a Single Select Dropdown (Y or N) if the corresponding PO exists. As standard, I'm using IFERROR to populate to ensure if there are errors it shows a more user friendly message. =IFERROR(INDEX({QC sheet Range 1}, MATCH([Product PO#]@row, {QC sheet PO Number}, 0), \"Task…","categoryID":321,"dateInserted":"2023-03-16T11:48:26+00:00","dateUpdated":null,"dateLastComment":"2023-03-16T13:52:35+00:00","insertUserID":146974,"insertUser":{"userID":146974,"name":"Jack Parry","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Parry","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-16T13:53:39+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-03-17T17:39:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3357942661,"url":"https:\/\/community.smartsheet.com\/discussion\/102727\/index-match-on-blank-and-no-matches","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102727\/index-match-on-blank-and-no-matches","format":"Rich","lastPost":{"discussionID":102727,"commentID":367552,"name":"Re: INDEX\/MATCH on Blank and No Matches","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/367552#Comment_367552","dateInserted":"2023-03-16T13:52:35+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-03-17T17:39:32+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-03-16T13:56:19+00:00","dateAnswered":"2023-03-16T13:52:35+00:00","acceptedAnswers":[{"commentID":367552,"body":"

Your syntax is off. The \"Task Not Complete\" portion is actually set in the column_number portion of the INDEX function, and you don't technically have an output established for the IFERROR. Take one of the closing parenthesis from the end and move it to before the comma prior to \"Task Not Complete\" to close out the INDEX function first.<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">