@AllieB<\/a> <\/p>Yes - in your sheet, add a Created date column.<\/p>
-Peggy<\/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":106191,"type":"question","name":"Can't find how to enable % Complete column","excerpt":"I am new to the app working in a Trial window. I have searched the Help but cannot seem to resolve how to enable the % Complete column. Dependencies are enabled. System Settings only gives me options for \"None\" or \"Notes\" for a % Complete column. Only thing I seem to get is the ability to add custom columns. Any direction…","categoryID":321,"dateInserted":"2023-06-08T13:26:39+00:00","dateUpdated":"2023-06-08T13:35:37+00:00","dateLastComment":"2023-06-08T13:40:28+00:00","insertUserID":162189,"insertUser":{"userID":162189,"name":"BillB","url":"https:\/\/community.smartsheet.com\/profile\/BillB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T15:50:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162189,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-08T18:12:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3372463627,"url":"https:\/\/community.smartsheet.com\/discussion\/106191\/cant-find-how-to-enable-complete-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106191\/cant-find-how-to-enable-complete-column","format":"Rich","lastPost":{"discussionID":106191,"commentID":379545,"name":"Re: Can't find how to enable % Complete column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379545#Comment_379545","dateInserted":"2023-06-08T13:40:28+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-06-08T18:12:02+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-06-08T13:42:55+00:00","dateAnswered":"2023-06-08T13:40:06+00:00","acceptedAnswers":[{"commentID":379543,"body":"
After hours of searching, I seemed to have figured this out as soon as I posted the question. Issue resolved.<\/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":106183,"type":"question","name":"How can I update cell 1 with the information from cell 2 when cell 3 is \"1\"?","excerpt":"Hi, I want the selected cell in Column19 to pull through A, B, C, D, E or F if the search filed has a \"1\" in it. I have tried INDEX MATCH, nested IFS, but nothing seems to work. Closest I got was a 'No Match', but not sure why the corresponding letter was not pulling through. This is all on the same sheet with columns…","categoryID":321,"dateInserted":"2023-06-08T08:56:55+00:00","dateUpdated":"2023-06-08T11:08:13+00:00","dateLastComment":"2023-06-08T13:55:23+00:00","insertUserID":159257,"insertUser":{"userID":159257,"name":"VLD","url":"https:\/\/community.smartsheet.com\/profile\/VLD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pnNRKRSmtPo!c9FehyaSxfo!nfYZy9I8YfN","dateLastActive":"2023-06-08T14:53:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":159257,"lastUser":{"userID":159257,"name":"VLD","url":"https:\/\/community.smartsheet.com\/profile\/VLD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pnNRKRSmtPo!c9FehyaSxfo!nfYZy9I8YfN","dateLastActive":"2023-06-08T14:53:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3372448338,"url":"https:\/\/community.smartsheet.com\/discussion\/106183\/how-can-i-update-cell-1-with-the-information-from-cell-2-when-cell-3-is-1","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106183\/how-can-i-update-cell-1-with-the-information-from-cell-2-when-cell-3-is-1","format":"Rich","lastPost":{"discussionID":106183,"commentID":379556,"name":"Re: How can I update cell 1 with the information from cell 2 when cell 3 is \"1\"?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379556#Comment_379556","dateInserted":"2023-06-08T13:55:23+00:00","insertUserID":159257,"insertUser":{"userID":159257,"name":"VLD","url":"https:\/\/community.smartsheet.com\/profile\/VLD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pnNRKRSmtPo!c9FehyaSxfo!nfYZy9I8YfN","dateLastActive":"2023-06-08T14:53:11+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/R1F0AVAKHTU9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T13:55:28+00:00","dateAnswered":"2023-06-08T12:28:29+00:00","acceptedAnswers":[{"commentID":379512,"body":"
=IF([Column13] = \"F\", \"Name 1\", IF([Column8] = 1, \"A\", IF([Column9] = 1, \"B\", IF([Column10] = 1, \"C\", IF([Column11] = 1, \"D\", IF([Column12] = 1, \"E\", IF([Column13] = 1, \"F\", \"//www.santa-greenland.com/community/discussion/101661/\")))))))<\/p>
This will work as long as only one column contains \"1\". If you need to return multiple results, you will need a different approach. This should also be setup as a column formula and will retain the \"Name 1\" cell.<\/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":[]}">
Trending in Using Smartsheet
Multiple Forms, One Smartsheet I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?
Can't find how to enable % Complete column I am new to the app working in a Trial window. I have searched the Help but cannot seem to resolve how to enable the % Complete column. Dependencies are enabled. System Settings only gives me options for "None" or "Notes" for a % Complete column. Only thing I seem to get is the ability to add custom columns. Any direction…
How can I update cell 1 with the information from cell 2 when cell 3 is "1"? Hi, I want the selected cell in Column19 to pull through A, B, C, D, E or F if the search filed has a "1" in it. I have tried INDEX MATCH, nested IFS, but nothing seems to work. Closest I got was a 'No Match', but not sure why the corresponding letter was not pulling through. This is all on the same sheet with columns…
Andrée Starå ✭✭✭✭✭✭
Tina Rustvold ✭✭✭✭✭
