Formulas

=[Risk Score]@row, {RangeEnd}, <=[Risk Score]@row), 1) The problem is with the \"<\" symbol in the…","categoryID":322,"dateInserted":"2023-07-27T14:55:04+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T18:38:27+00:00","insertUserID":122906,"insertUser":{"userID":122906,"name":"Cesar Perez","url":"https:\/\/community.smartsheet.com\/profile\/Cesar%20Perez","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2uFV_3dM1no!ndnWXxsFlTw!JCwGNa_KQWy","dateLastActive":"2023-08-23T18:58:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":66,"score":null,"hot":3380955211,"url":"https:\/\/community.smartsheet.com\/discussion\/108186\/index-collect-does-not-work-with-symbol","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108186\/index-collect-does-not-work-with-symbol","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JURDPT6GMX1Y\/formula.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T15:36:00+00:00","dateAnswered":"2023-07-27T15:02:42+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"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":108110,"type":"question","name":"Need an Formula to generate Categories column","excerpt":"We are looking for the Categories to auto generate from the sub-categories multi dropdown selection. We were achieved this by using the =IF(COUNTIF([Sub-Categories]@row, CONTAINS(\"Fruits\", @cell)) >= 1, \"Fruits\") + CHAR(10) + IF(COUNTIF([Sub-Categories]@row, CONTAINS(\"Meats\", @cell)) >= 1, \"Meats\") + CHAR(10) +…","categoryID":322,"dateInserted":"2023-07-26T16:02:47+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T15:19:15+00:00","insertUserID":164083,"insertUser":{"userID":164083,"name":"Gaja Rm","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Gaja%20Rm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T17:13:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":64,"score":null,"hot":3380860322,"url":"https:\/\/community.smartsheet.com\/discussion\/108110\/need-an-formula-to-generate-categories-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108110\/need-an-formula-to-generate-categories-column","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/N1P5SKYOMK3X\/categories-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Categories.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-26T18:14:44+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"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":108135,"type":"question","name":"Best way to set-up an index contains","excerpt":"Hello Smartsheet, I have a sheet with URLs from our website that I need to be able to flag by division. To do this I have set-up a master sheet with the division's name and base URLs. What I need now is a formula to grab the division names from the master sheet. My intent was to set it up as an INDEX(MATCH()) but I realize…","categoryID":322,"dateInserted":"2023-07-26T19:41:14+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T14:30:41+00:00","insertUserID":153351,"insertUser":{"userID":153351,"name":"Megan_Perry_Thibault","url":"https:\/\/community.smartsheet.com\/profile\/Megan_Perry_Thibault","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WrnoX85eVrI!XPdr38YOBrI!EPuQzPSnyok","dateLastActive":"2023-07-27T12:28:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":77,"score":null,"hot":3380872315,"url":"https:\/\/community.smartsheet.com\/discussion\/108135\/best-way-to-set-up-an-index-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108135\/best-way-to-set-up-an-index-contains","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-27T12:28:03+00:00","dateAnswered":"2023-07-26T20:51:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"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":51601,"type":"discussion","name":"CountIF \/ IsDate combination","excerpt":"Hello I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.","categoryID":322,"dateInserted":"2019-06-26T12:22:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-07-27T11:58:24+00:00","insertUserID":93966,"insertUser":{"userID":93966,"name":"angel.blanquet93966","url":"https:\/\/community.smartsheet.com\/profile\/angel.blanquet93966","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-26T12:16:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-27T07:46:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":21,"countViews":756,"score":null,"hot":3252023457,"url":"https:\/\/community.smartsheet.com\/discussion\/51601\/countif-isdate-combination","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/51601\/countif-isdate-combination","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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":19406,"type":"discussion","name":"VLOOKUP to another sheet using images","excerpt":"I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the image. This would be so useful to actually pull in the image itself as a…","categoryID":322,"dateInserted":"2018-02-12T20:13:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-07-27T11:33:14+00:00","insertUserID":37286,"insertUser":{"userID":37286,"name":"caroline_allen37286","url":"https:\/\/community.smartsheet.com\/profile\/caroline_allen37286","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-12T20:07:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144591,"lastUser":{"userID":144591,"name":"Jim B","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-11T13:37:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":20,"countViews":1525,"score":null,"hot":3208935981,"url":"https:\/\/community.smartsheet.com\/discussion\/19406\/vlookup-to-another-sheet-using-images","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19406\/vlookup-to-another-sheet-using-images","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":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":108160,"type":"question","name":"Copy updated cell values of one sheet to another","excerpt":"Hi, I have two sheets with exact same columns. When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well. Please help how it can be accomplished. Example: Let say Price Per unit of Row 3 is changed in first…","categoryID":322,"dateInserted":"2023-07-27T04:01:40+00:00","dateUpdated":"2023-07-27T07:13:41+00:00","dateLastComment":"2023-07-27T07:41:31+00:00","insertUserID":164152,"insertUser":{"userID":164152,"name":"JasG","title":"Dev","url":"https:\/\/community.smartsheet.com\/profile\/JasG","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T17:14:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164152,"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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":65,"score":null,"hot":3380874791,"url":"https:\/\/community.smartsheet.com\/discussion\/108160\/copy-updated-cell-values-of-one-sheet-to-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108160\/copy-updated-cell-values-of-one-sheet-to-another","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A1DSA5JBUSCA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-27T07:41:31+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":108082,"type":"question","name":"Cell-linking - counting values from a sheet into the cell of another sheet","excerpt":"Hi everyone, I'm trying to create an event summary sheet that captures data from individual event sheets to provide a live overview on where we're at with completion, health, risks, status, etc. And so I have a cell \"Health\" in my specific event sheet that has a number of dots (red, green, gray) depending on with the task…","categoryID":322,"dateInserted":"2023-07-26T04:51:56+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T07:40:19+00:00","insertUserID":103656,"insertUser":{"userID":103656,"name":"axelrodo","url":"https:\/\/community.smartsheet.com\/profile\/axelrodo","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5OHAuRriZn4!!NReNPAq4zpH","dateLastActive":"2023-08-16T03:55:40+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":70,"score":null,"hot":3380793735,"url":"https:\/\/community.smartsheet.com\/discussion\/108082\/cell-linking-counting-values-from-a-sheet-into-the-cell-of-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108082\/cell-linking-counting-values-from-a-sheet-into-the-cell-of-another-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-26T05:24:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":108148,"type":"question","name":"Join IF Contact Type = Customer","excerpt":"I have a sheet with the following columns: Contact Type | Email In the Sheet Summary, I have a field where I would like to create an email string that can easily be used to paste a bunch of email separated by a semi-colon for easy sharing. I want to join all emails where Contact Type is \"Customer\" into a single field with…","categoryID":322,"dateInserted":"2023-07-26T21:12:18+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T01:08:38+00:00","insertUserID":155497,"insertUser":{"userID":155497,"name":"JSpears","url":"https:\/\/community.smartsheet.com\/profile\/JSpears","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BgDcwSo-92c!7zlc-6IqQLs!HEmr4KUqqxd","dateLastActive":"2023-08-14T17:00:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":76,"score":null,"hot":3380829056,"url":"https:\/\/community.smartsheet.com\/discussion\/108148\/join-if-contact-type-customer","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108148\/join-if-contact-type-customer","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-03T14:01:31+00:00","dateAnswered":"2023-07-26T21:42:59+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">