表

Project Sheet...Why so difficult????????????????????????","excerpt":"All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…","categoryID":321,"dateInserted":"2022-08-20T21:28:29+00:00","dateUpdated":null,"dateLastComment":"2022-08-23T15:28:38+00:00","insertUserID":145413,"insertUser":{"userID":145413,"name":"EEK","url":"https:\/\/community.smartsheet.com\/profile\/EEK","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pNkp6S_frTs!84Mod7_pwws!Y0MowOIWO0N","dateLastActive":"2022-08-23T15:27:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145413,"lastUser":{"userID":145413,"name":"EEK","url":"https:\/\/community.smartsheet.com\/profile\/EEK","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pNkp6S_frTs!84Mod7_pwws!Y0MowOIWO0N","dateLastActive":"2022-08-23T15:27:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":56,"score":null,"hot":3322302427,"url":"https:\/\/community.smartsheet.com\/discussion\/94503\/intake-data-project-sheet-why-so-difficult","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94503\/intake-data-project-sheet-why-so-difficult","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/mail.google.com\/mail\/u\/1?ui=2&ik=36e8cc97d5&attid=0.4&permmsgid=msg-a:r-4904289525971870772&th=182bd1103689e889&view=fimg&fur=ip&sz=s0-l75-ft&attbid=ANGjdJ81ruX4rRksxqdYsMMirV6VnJ1J7i6QmFbNxx9BunTLimnlhjS3tlRTxxKJAQkqxU92m7d5iuiXPlWgnMy8Ux2_wOekWCdmu8cKq2WQpCb0jg9gbd-K8_GZs_I&disp=emb&realattid=ii_l72dw9ts5","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-21T01:23:21+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":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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":88776,"type":"discussion","name":"Reports and Dashboards break if column is renamed in a Sheet","excerpt":"Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.","categoryID":321,"dateInserted":"2022-03-08T23:50:53+00:00","dateUpdated":"2022-03-08T23:52:26+00:00","dateLastComment":"2022-08-23T15:09:21+00:00","insertUserID":95091,"insertUser":{"userID":95091,"name":"Sameer Karkhanis","url":"https:\/\/community.smartsheet.com\/profile\/Sameer%20Karkhanis","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Gojd36hb2yQ!xWjdseh3KiQ!Pg1PywniI56","dateLastActive":"2022-09-02T23:53:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":95091,"lastUserID":149577,"lastUser":{"userID":149577,"name":"Henry Park","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Henry%20Park","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-23T15:08:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":66,"score":1,"hot":3308051714,"url":"https:\/\/community.smartsheet.com\/discussion\/88776\/reports-and-dashboards-break-if-column-is-renamed-in-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88776\/reports-and-dashboards-break-if-column-is-renamed-in-a-sheet","format":"Rich","groupID":null,"statusID":0,"attributes":{},"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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">