When clicking on a search result, you will go directly to that result instead of the top of the sheet containing that result. However, if you only want to go to the sheet containing the search result, click the icon to the right of the sheet name. <\/li><\/ol>We'll keep you updated with any new improvements to the Search experience.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 12:13:12","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-12-09T16:26:03+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","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":3}],"tags":[]},{"discussionID":98637,"type":"question","name":"Forms - can fields be side by side versus below","excerpt":"I'm working on creating a form but we would prefer that the fields be next to each other for comparisons instead of below. Is that possible?","categoryID":322,"dateInserted":"2022-12-09T20:05:44+00:00","dateUpdated":"2022-12-09T20:06:53+00:00","dateLastComment":"2022-12-09T20:09:41+00:00","insertUserID":155858,"insertUser":{"userID":155858,"name":"connett","url":"https:\/\/community.smartsheet.com\/profile\/connett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T20:10:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":155858,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-12T01:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3341234125,"url":"https:\/\/community.smartsheet.com\/discussion\/98637\/forms-can-fields-be-side-by-side-versus-below","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98637\/forms-can-fields-be-side-by-side-versus-below","format":"Rich","lastPost":{"discussionID":98637,"commentID":353893,"name":"Re: Forms - can fields be side by side versus below","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353893#Comment_353893","dateInserted":"2022-12-09T20:09:41+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-12-12T01:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-09T20:11:47+00:00","dateAnswered":"2022-12-09T20:07:51+00:00","acceptedAnswers":[{"commentID":353892,"body":"
@connett<\/a> Unfortunately, no. Not with Smartsheet forms.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-09 20:11:47","updateUser":{"userID":155858,"name":"connett","url":"https:\/\/community.smartsheet.com\/profile\/connett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T20:10:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":98633,"type":"question","name":"Copy\/Paste Permission Issue","excerpt":"I have a member of my team that attempted to copy\/paste some information from a sheet where his permission level is \"Editor - can share\" to another sheet where his permission level is the exact same, but was told he could not. Full disclosure we have a workspace and that is his default permission level so anything added…","categoryID":321,"dateInserted":"2022-12-09T19:23:12+00:00","dateUpdated":null,"dateLastComment":"2022-12-09T19:43:35+00:00","insertUserID":148057,"insertUser":{"userID":148057,"name":"Karina","url":"https:\/\/community.smartsheet.com\/profile\/Karina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5R1R-YDebsQ!kp1QfwDqesQ!DXaLPzZ3DxJ","dateLastActive":"2022-12-09T19:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148057,"lastUser":{"userID":148057,"name":"Karina","url":"https:\/\/community.smartsheet.com\/profile\/Karina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5R1R-YDebsQ!kp1QfwDqesQ!DXaLPzZ3DxJ","dateLastActive":"2022-12-09T19:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3341230007,"url":"https:\/\/community.smartsheet.com\/discussion\/98633\/copy-paste-permission-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98633\/copy-paste-permission-issue","format":"Rich","tagIDs":[219,245],"lastPost":{"discussionID":98633,"commentID":353887,"name":"Re: Copy\/Paste Permission Issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353887#Comment_353887","dateInserted":"2022-12-09T19:43:35+00:00","insertUserID":148057,"insertUser":{"userID":148057,"name":"Karina","url":"https:\/\/community.smartsheet.com\/profile\/Karina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5R1R-YDebsQ!kp1QfwDqesQ!DXaLPzZ3DxJ","dateLastActive":"2022-12-09T19:42:36+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\/GSMXV5D4AEL3\/copy-screenshot-1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Copy Screenshot 1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-09T19:43:42+00:00","dateAnswered":"2022-12-09T19:33:06+00:00","acceptedAnswers":[{"commentID":353883,"body":"Double check the column names and types. If they are not an exact match and\/or there is a column in the sheet he is copying from that is not in the sheet he is copying to, then the copy row will want to create a new column that has a matching name and type. You must have Admin or Owner permissions to create a new column. So the issue may not necessarily be related to permissions required to copy a row but more permissions to create a new column. You will even need to double check any \"hidden\" columns as those would copy over as well.<\/p>
<\/p>
- \"Your source and destination columns should have the same column names. If the source and destination sheets have different column names or types, data from the row you copied appears in new columns to the right of the existing columns in the destination sheet. If this occurs, scroll to the right to find the data, copy it, then paste it into the desired columns.\"<\/li><\/ul>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-09 19:43:42","updateUser":{"userID":148057,"name":"Karina","url":"https:\/\/community.smartsheet.com\/profile\/Karina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5R1R-YDebsQ!kp1QfwDqesQ!DXaLPzZ3DxJ","dateLastActive":"2022-12-09T19:42:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"}]},{"discussionID":98632,"type":"question","name":"Formula for If Date is Blank or Not Blank, set Status symbol to Red\/Green","excerpt":"Hi everyone!! I am struggling with finding the correct formula to indicate status of task (shown by symbols) based on if a date is submitted into another cell. In words, I'd like to have the formula be set to make the status symbol \"Green\" if Column \"Date\" is not blank. I would also like the formula to make the status…","categoryID":322,"dateInserted":"2022-12-09T18:56:55+00:00","dateUpdated":null,"dateLastComment":"2022-12-09T19:43:16+00:00","insertUserID":152534,"insertUser":{"userID":152534,"name":"Jessewise","url":"https:\/\/community.smartsheet.com\/profile\/Jessewise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T19:45:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152534,"lastUser":{"userID":152534,"name":"Jessewise","url":"https:\/\/community.smartsheet.com\/profile\/Jessewise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T19:45:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3341229011,"url":"https:\/\/community.smartsheet.com\/discussion\/98632\/formula-for-if-date-is-blank-or-not-blank-set-status-symbol-to-red-green","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98632\/formula-for-if-date-is-blank-or-not-blank-set-status-symbol-to-red-green","format":"Rich","lastPost":{"discussionID":98632,"commentID":353886,"name":"Re: Formula for If Date is Blank or Not Blank, set Status symbol to Red\/Green","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353886#Comment_353886","dateInserted":"2022-12-09T19:43:16+00:00","insertUserID":152534,"insertUser":{"userID":152534,"name":"Jessewise","url":"https:\/\/community.smartsheet.com\/profile\/Jessewise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T19:45:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-09T19:42:54+00:00","dateAnswered":"2022-12-09T19:27:00+00:00","acceptedAnswers":[{"commentID":353882,"body":"
Try this:<\/p>
=IF(Date@row <> \"//www.santa-greenland.com/community/categories/c2015/\", \"Green\", \"Red\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-09 19:42:54","updateUser":{"userID":152534,"name":"Jessewise","url":"https:\/\/community.smartsheet.com\/profile\/Jessewise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-09T19:45:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">