transfer a line from one sheet to another when a certain criterion is met
I want to transfer a line from one sheet to another when a certain criterion is given.how can i do it?
Comments
-
Andrée Starå ✭✭✭✭✭✭Hi,
You could set this up with the help of a service like Zapier or similar.
Would that work for you?
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Help Article Resources
Categories
=COUNTIFS([Date in Job]2:[Date in Job]76, AND(@cell >= DATE(2023, 07, 01), @cell <= DATE(2023, 07, 31)))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":108030,"type":"question","name":"Invalid Data Type on an IF function with Index Collect","excerpt":"Hi All, I am trying to nest and index collect into an IF but I keep on getting Invalid Data Type. =IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, \"LATE\"), 1), \"LATE\", IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row, {Tracker - Range 5}, \"On…","snippet":"Hi All, I am trying to nest and index collect into an IF but I keep on getting Invalid Data Type. =IF(INDEX(COLLECT({Tracker - Range 5}, {Tracker - Range 2}, [Project Name]@row,…","categoryID":322,"dateInserted":"2023-07-25T14:22:16+00:00","dateUpdated":null,"dateLastComment":"2023-07-25T17:47:12+00:00","insertUserID":151347,"insertUser":{"userID":151347,"name":"MegBurns23","url":"https:\/\/community.smartsheet.com\/profile\/MegBurns23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3JFev2akC_o!bRNeG5LETzw!9HYHhXoqNPO","dateLastActive":"2023-07-25T17:49:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162305,"lastUser":{"userID":162305,"name":"Cory Page","title":"Revenue Cycle Analyst & Informatics","url":"https:\/\/community.smartsheet.com\/profile\/Cory%20Page","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-25T19:00:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":96,"score":null,"hot":3380608768,"url":"https:\/\/community.smartsheet.com\/discussion\/108030\/invalid-data-type-on-an-if-function-with-index-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108030\/invalid-data-type-on-an-if-function-with-index-collect","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108030,"commentID":386960,"name":"Re: Invalid Data Type on an IF function with Index Collect","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386960#Comment_386960","dateInserted":"2023-07-25T17:47:12+00:00","insertUserID":162305,"insertUser":{"userID":162305,"name":"Cory Page","title":"Revenue Cycle Analyst & Informatics","url":"https:\/\/community.smartsheet.com\/profile\/Cory%20Page","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-25T19:00:15+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-25T17:42:25+00:00","dateAnswered":"2023-07-25T17:28:08+00:00","acceptedAnswers":[{"commentID":386950,"body":"
@MegBurns23<\/a> Thanks for all the information sorry it took a bit. <\/p> Its not a collect statement but sometimes keeping something as simple as possible really makes things easy so just in case you wanted to try something a little different here is one I ended up getting to work. <\/p> Its basically counting the number of Late instances then anything greater than 0 would mean the project is late other wise its On time. Update: Sorry i didn't drop the correct formula fixed now<\/p> =IF(COUNTIFS([Late or on time]3:[Late or on time]44, =\"Late\", [Project Name]3:[Project Name]44, [Other sheet Primary]@row) > \"0\", \"Late\", \"On Time\")<\/p>![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/FMCK3BIWQU32\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LKNUKV3LTQ41\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
