Archived 2015 Posts

Will this work for you?<\/p>

=IFERROR(INDEX(COLLECT({Historical Roster Range 1}, {Historical Roster Range 2}, AND(ISDATE(@cell), @cell <= [Completion Date:]@row, @cell >= [Completion Date:]@row - 7)), 1),\"//www.santa-greenland.com/community/categories/c2015/\")<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-28 13:10:52","updateUser":{"userID":128829,"name":"Justin Mauzy","url":"https:\/\/community.smartsheet.com\/profile\/Justin%20Mauzy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-28T13:23:46+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":99081,"type":"question","name":"Change Symbol based on date \/ clear if blank","excerpt":"I'm wanting the symbol to change based on the date field. If date is today (or in the past), Red If date is tomorrow, turn Yellow If date is past tomorrow (in the future), Green If date is blank, Blank - No color\/Symbol This was working to some degree, and somehow I broke it.... :) =IF([Scheduled End Date]@row <= TODAY(),…","categoryID":322,"dateInserted":"2022-12-27T20:10:41+00:00","dateUpdated":"2022-12-27T20:11:17+00:00","dateLastComment":"2022-12-27T22:50:37+00:00","insertUserID":125814,"insertUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-12-28T13:58:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":125814,"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-28T14:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3344355078,"url":"https:\/\/community.smartsheet.com\/discussion\/99081\/change-symbol-based-on-date-clear-if-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99081\/change-symbol-based-on-date-clear-if-blank","format":"Rich","lastPost":{"discussionID":99081,"commentID":355401,"name":"Re: Change Symbol based on date \/ clear if blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355401#Comment_355401","dateInserted":"2022-12-27T22:50:37+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-28T14:05:43+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-27T20:28:58+00:00","dateAnswered":"2022-12-27T20:28:55+00:00","acceptedAnswers":[{"commentID":355391,"body":"

Fantastic! you're a genius! Thank you<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-27 20:28:58","updateUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-12-28T13:58:53+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":99075,"type":"question","name":"Find and replace or substitute","excerpt":"Hello, What is the best way to turn ###-###-#### into ########## ? Some entries have parentheses, dashes or spaces, but it needs to pull just the numbers. I figured it would be either find and replace or substitute, but I'm not sure if I need an additional app to do those. Any help would be appreciated!","categoryID":322,"dateInserted":"2022-12-27T17:46:35+00:00","dateUpdated":"2022-12-27T18:08:57+00:00","dateLastComment":"2022-12-27T18:42:29+00:00","insertUserID":137936,"insertUser":{"userID":137936,"name":"Desertbird","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Desertbird","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-27T19:09:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":137936,"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-28T14:05:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3344330944,"url":"https:\/\/community.smartsheet.com\/discussion\/99075\/find-and-replace-or-substitute","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99075\/find-and-replace-or-substitute","format":"Rich","lastPost":{"discussionID":99075,"commentID":355384,"name":"Re: Find and replace or substitute","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355384#Comment_355384","dateInserted":"2022-12-27T18:42:29+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-28T14:05:43+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-27T19:09:26+00:00","dateAnswered":"2022-12-27T18:42:29+00:00","acceptedAnswers":[{"commentID":355384,"body":"