\n
In that case you would use<\/p>
=\"kc\" + RIGHT([Column Name]@row, LEN([Column name]@row) - (FIND(\"-\", [Column Name]@row) + 2))<\/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":108540,"type":"question","name":"How can I update a checkbox on a sheet based off of criteria from another sheet?","excerpt":"I'm trying to update a checkbox on a sheet based off of criteria from another sheet. I've seen several examples using the INDEX \/ MATCH function but haven't had any luck because the situations seem to be a little different than mine. Here is my situation: Sheet 1: Time Tracking - updated by each employee each week via a…","snippet":"I'm trying to update a checkbox on a sheet based off of criteria from another sheet. I've seen several examples using the INDEX \/ MATCH function but haven't had any luck because…","categoryID":321,"dateInserted":"2023-08-04T16:05:43+00:00","dateUpdated":"2023-08-04T17:19:39+00:00","dateLastComment":"2023-08-07T12:26:19+00:00","insertUserID":144833,"insertUser":{"userID":144833,"name":"Tana V","url":"https:\/\/community.smartsheet.com\/profile\/Tana%20V","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xIfp8WvfKzM!BqnoQUvuP7M!zhz8Yul5dPv","dateLastActive":"2023-08-04T22:00:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":144833,"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-08-07T12:22:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":49,"score":null,"hot":3382578122,"url":"https:\/\/community.smartsheet.com\/discussion\/108540\/how-can-i-update-a-checkbox-on-a-sheet-based-off-of-criteria-from-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108540\/how-can-i-update-a-checkbox-on-a-sheet-based-off-of-criteria-from-another-sheet","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108540,"commentID":389173,"name":"Re: How can I update a checkbox on a sheet based off of criteria from another sheet?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389173#Comment_389173","dateInserted":"2023-08-07T12:26:19+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-08-07T12:22:09+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FX55FDBTGBGR\/snag-130d01cb.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Snag_130d01cb.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-04T22:00:25+00:00","dateAnswered":"2023-08-04T18:46:52+00:00","acceptedAnswers":[{"commentID":389011,"body":"
You would use an IF\/COUNTIFS combo to count how many rows have the employee ID and the Week Starting. If that count is greater than zero (meaning there was at least one entry), check the box.<\/p>
=IF(COUNTIFS({Source Sheet EMP ID}, @cell = [Employee ID]@row, {Source Sheet Week Starting}, @cell = \"7\/10\/2023\")> 0, 1)<\/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":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":4918,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Smartsheet Basics
Paul Newcome ✭✭✭✭✭✭![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/LAFS59XB5GYB\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
