Search

Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…","categoryID":322,"dateInserted":"2019-04-22T12:24:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-22T13:34:12+00:00","insertUserID":58936,"insertUser":{"userID":58936,"name":"Ezra","url":"https:\/\/community.smartsheet.com\/profile\/Ezra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/722\/n8VN7BXAAHKNJ.png","dateLastActive":"2020-07-17T14:29:53+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-08-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":195,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/46346\/generate-list-of-recently-updated-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/46346\/generate-list-of-recently-updated-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":37441,"type":"discussion","name":"The \"New Smartsheet Navigation Experience\" is Great! TY!","excerpt":"The New Smartsheet Navigation Experience is GREAT! The #1 feature I'm excited about is Browser Tabs and Direct Links. Being able to copy the URL straight from the browser. I spent a LOT of time as a champion and mentor explaining how to get the URL to share a specific sheet. I really believe this will enhance the new user…","categoryID":321,"dateInserted":"2018-12-14T08:35:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-12T12:01:57+00:00","insertUserID":5490,"insertUser":{"userID":5490,"name":"KrisWalsh","url":"https:\/\/community.smartsheet.com\/profile\/KrisWalsh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/8a\/70\/n8a707e01310d7ba71d4d96329c6f90c0.jpg","dateLastActive":"2020-01-13T16:15:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":40181,"lastUser":{"userID":40181,"name":"Donia Strand","url":"https:\/\/community.smartsheet.com\/profile\/Donia%20Strand","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-12T11:57:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":78,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/37441\/the-new-smartsheet-navigation-experience-is-great-ty","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37441\/the-new-smartsheet-navigation-experience-is-great-ty","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/teeth_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"laugh"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":215,"urlcode":"templates","name":"Templates"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":223,"urlcode":"publish","name":"Publish"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":45611,"type":"discussion","name":"Status Change if Column Checked","excerpt":"Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…","categoryID":322,"dateInserted":"2019-04-10T16:36:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-12T04:36:40+00:00","insertUserID":44871,"insertUser":{"userID":44871,"name":"lisarae723","url":"https:\/\/community.smartsheet.com\/profile\/lisarae723","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T19:30:34+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-08-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":735,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45611\/status-change-if-column-checked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45611\/status-change-if-column-checked","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/3d\/61\/3d610012ad281e1b96e0c62a509f81bc.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Approval Status.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":44186,"type":"discussion","name":"Help with SUMIFS & INDEX\/MATCH Formulas","excerpt":"I need to first find the column number where the number 1 resides on the \"Lookup Value -->\" row. Next, I need to shift two columns to the right, which would be \"4\/2019 C\" and sum the values for Client B, I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE…","categoryID":322,"dateInserted":"2019-03-22T16:46:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-27T11:42:34+00:00","insertUserID":49351,"insertUser":{"userID":49351,"name":"Dan Seidler","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Seidler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-05T21:53:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":49351,"lastUser":{"userID":49351,"name":"Dan Seidler","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Seidler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-05T21:53:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":6302,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/44186\/help-with-sumifs-index-match-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44186\/help-with-sumifs-index-match-formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-03\/3a\/eb\/3aeb18bf96fe93e0bf75595281955513.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SS-ExampleA.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"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":44076,"type":"discussion","name":"Auto Number Formatting","excerpt":"Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…","categoryID":322,"dateInserted":"2019-03-21T10:07:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-22T14:06:14+00:00","insertUserID":44871,"insertUser":{"userID":44871,"name":"lisarae723","url":"https:\/\/community.smartsheet.com\/profile\/lisarae723","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-18T19:30:34+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-08-26T14:46:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":617,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/44076\/auto-number-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/44076\/auto-number-formatting","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":43296,"type":"discussion","name":"Problem with search bar","excerpt":"I type text in search bar, but the search function doesn't pull the information, even though its in a sheet. I have cleared any\/all filters. Not sure why it won't pull the information. It's clearly in the sheets. I screenshot information in one of the sheets in question. I also showed the search results not pulling the…","categoryID":321,"dateInserted":"2019-03-11T10:34:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-12T09:20:05+00:00","insertUserID":50951,"insertUser":{"userID":50951,"name":"steve50951","url":"https:\/\/community.smartsheet.com\/profile\/steve50951","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-16T18:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":50951,"lastUser":{"userID":50951,"name":"steve50951","url":"https:\/\/community.smartsheet.com\/profile\/steve50951","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-16T18:38:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":677,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/43296\/problem-with-search-bar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43296\/problem-with-search-bar","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-03\/d7\/4a\/d74a32f4f30977eb4129947051c73123.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2019-03-11 at 9.31.06 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":214,"urlcode":"search","name":"Search"}],"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}">