支持

TODAY(), \"In Progress\", \"Complete\")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…","categoryID":322,"dateInserted":"2022-09-27T13:44:09+00:00","dateUpdated":null,"dateLastComment":"2022-09-27T20:16:12+00:00","insertUserID":152857,"insertUser":{"userID":152857,"name":"bailey99","url":"https:\/\/community.smartsheet.com\/profile\/bailey99","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUMu8Tpr6Io!upNuJ7YWmzo!sYIyLIKqTzs","dateLastActive":"2022-10-20T14:22:28+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-11T12:14:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":156,"score":null,"hot":3328598421,"url":"https:\/\/community.smartsheet.com\/discussion\/95944\/invalid-operation-when-using-today-in-nested-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95944\/invalid-operation-when-using-today-in-nested-if-statement","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-27T17:02:54+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}]},{"discussionID":95956,"type":"question","name":"Is it best to link only one predecessor to each task or is it ok to have multiple?","excerpt":"I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…","categoryID":321,"dateInserted":"2022-09-27T17:03:42+00:00","dateUpdated":"2022-09-27T17:04:26+00:00","dateLastComment":"2022-09-27T18:03:11+00:00","insertUserID":152892,"insertUser":{"userID":152892,"name":"lbell","url":"https:\/\/community.smartsheet.com\/profile\/lbell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-19T15:22:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":152892,"lastUserID":151285,"lastUser":{"userID":151285,"name":"PWNA Sam Harwart","title":"","url":"https:\/\/community.smartsheet.com\/profile\/PWNA%20Sam%20Harwart","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJ1TQQS66sU!86nRd5yLxD0!Fqg6-EE4vDZ","dateLastActive":"2023-05-16T14:31:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":131,"score":null,"hot":3328600613,"url":"https:\/\/community.smartsheet.com\/discussion\/95956\/is-it-best-to-link-only-one-predecessor-to-each-task-or-is-it-ok-to-have-multiple","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95956\/is-it-best-to-link-only-one-predecessor-to-each-task-or-is-it-ok-to-have-multiple","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-27T18:43:00+00:00","dateAnswered":"2022-09-27T18:03:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":20306,"type":"question","name":"Create Chart Widget Using a Report (not a Sheet)","excerpt":"With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly \"submission date\" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…","categoryID":321,"dateInserted":"2018-02-26T13:43:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-09-27T16:02:19+00:00","insertUserID":5179,"insertUser":{"userID":5179,"name":"Pam Tadsen","url":"https:\/\/community.smartsheet.com\/profile\/Pam%20Tadsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OWFQO4OSOT1P\/nUVOG870WGDCQ.jpg","dateLastActive":"2023-06-06T15:28:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-09T16:55:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":18,"countViews":3635,"score":null,"hot":3183957959,"url":"https:\/\/community.smartsheet.com\/discussion\/20306\/create-chart-widget-using-a-report-not-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20306\/create-chart-widget-using-a-report-not-a-sheet","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-03-03T10:37:54+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}],"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}]},{"discussionID":95916,"type":"question","name":"COUNTIF with keywords","excerpt":"Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. \"communication\"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS(\"communication\", [Job Classification]:[Job…","categoryID":322,"dateInserted":"2022-09-26T19:57:57+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T20:58:08+00:00","insertUserID":132547,"insertUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-05T12:06:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":132547,"lastUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-05T12:06:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":201,"score":null,"hot":3328449365,"url":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T21:10:03+00:00","dateAnswered":"2022-09-26T20:03:18+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":95832,"type":"question","name":"I imputed a date that was 09.01.22 and yet the png shows 01.01.22","excerpt":"I completed a gantt chart shown here and as you can see my start date is 09.01.22 and yet the gantt charct shows january february, etc., this is ridiculous and completely ruins my chart and I didn't even input those values. If anyone could help me in removing them I would be grateful, thank you.","categoryID":321,"dateInserted":"2022-09-23T01:22:23+00:00","dateUpdated":null,"dateLastComment":"2022-09-24T01:53:47+00:00","insertUserID":152769,"insertUser":{"userID":152769,"name":"emmak","url":"https:\/\/community.smartsheet.com\/profile\/emmak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-24T01:54:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152769,"lastUser":{"userID":152769,"name":"emmak","url":"https:\/\/community.smartsheet.com\/profile\/emmak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-24T01:54:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":129,"score":null,"hot":3327881770,"url":"https:\/\/community.smartsheet.com\/discussion\/95832\/i-imputed-a-date-that-was-09-01-22-and-yet-the-png-shows-01-01-22","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95832\/i-imputed-a-date-that-was-09-01-22-and-yet-the-png-shows-01-01-22","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2EP64E20691V\/homework-232-286-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"HOMEWORK #2 (6).png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-23T05:19:35+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"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}]},{"discussionID":95456,"type":"question","name":"Total Site % Complete + health","excerpt":"I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…","categoryID":322,"dateInserted":"2022-09-16T19:47:36+00:00","dateUpdated":"2022-09-16T19:52:04+00:00","dateLastComment":"2022-09-23T16:19:13+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151274,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":138,"score":null,"hot":3327309409,"url":"https:\/\/community.smartsheet.com\/discussion\/95456\/total-site-complete-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95456\/total-site-complete-health","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T19:08:11+00:00","dateAnswered":"2022-09-23T16:19:13+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":95777,"type":"question","name":"How to overrule a 0 multiplication formula returning 0 as an answer?","excerpt":"Hi all, haven't been able to find anything on this by searching so I'm posting. I'm hoping it is a simple fix as the formula seems very simple! I am attempting to calculate accident frequency rates at my company. I fully understand that anything multiplied by zero returns zero. However, if there have been no accidents I…","categoryID":322,"dateInserted":"2022-09-22T14:02:04+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T07:52:12+00:00","insertUserID":145999,"insertUser":{"userID":145999,"name":"Mick Tim","url":"https:\/\/community.smartsheet.com\/profile\/Mick%20Tim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-29T13:54:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":146,"score":null,"hot":3327777856,"url":"https:\/\/community.smartsheet.com\/discussion\/95777\/how-to-overrule-a-0-multiplication-formula-returning-0-as-an-answer","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95777\/how-to-overrule-a-0-multiplication-formula-returning-0-as-an-answer","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T07:45:59+00:00","dateAnswered":"2022-09-23T07:39:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}]},{"discussionID":95602,"type":"question","name":"VLookUp - #INCORRECT ARGUMENT SET","excerpt":"Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…","categoryID":322,"dateInserted":"2022-09-20T19:37:11+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T16:48:15+00:00","insertUserID":152537,"insertUser":{"userID":152537,"name":"dhkim18","url":"https:\/\/community.smartsheet.com\/profile\/dhkim18","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T21:11:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-11T11:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":108,"score":null,"hot":3327482126,"url":"https:\/\/community.smartsheet.com\/discussion\/95602\/vlookup-incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95602\/vlookup-incorrect-argument-set","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-21T16:48:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}]},{"discussionID":95595,"type":"question","name":"VLookUp - #INCORRECT ARGUMENT SET","excerpt":"Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…","categoryID":322,"dateInserted":"2022-09-20T19:12:21+00:00","dateUpdated":"2022-09-21T17:10:46+00:00","dateLastComment":"2022-09-21T09:10:15+00:00","insertUserID":152537,"insertUser":{"userID":152537,"name":"dhkim18","url":"https:\/\/community.smartsheet.com\/profile\/dhkim18","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T21:11:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"lastUserID":137711,"lastUser":{"userID":137711,"name":"SmartLew","title":"","url":"https:\/\/community.smartsheet.com\/profile\/SmartLew","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-29T13:14:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":450,"score":null,"hot":3327457356,"url":"https:\/\/community.smartsheet.com\/discussion\/95595\/vlookup-incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95595\/vlookup-incorrect-argument-set","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-21T17:09:48+00:00","dateAnswered":"2022-09-21T09:10:15+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">