Discussions
Profile > Add Photo. I then upload a photo. I ensure my visibility is checked. I can see my photo. I will then hit save and it goes back to the grey empty avatar. Does anyone know how to fix this?","categoryID":321,"dateInserted":"2023-02-03T15:42:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T22:50:50+00:00","insertUserID":139369,"insertUser":{"userID":139369,"name":"Cat.Cosby","url":"https:\/\/community.smartsheet.com\/profile\/Cat.Cosby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DA54FAXEIV61\/nVQNHQ6VMQVMD.png","dateLastActive":"2023-08-16T22:06:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":76736,"lastUser":{"userID":76736,"name":"Sarah Keortge","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Keortge","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pzVbKYHkoIQ!29HYv1nQZfw!6PeRZKuMdNC","dateLastActive":"2023-08-24T20:44:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":301,"score":1,"hot":3366029315,"url":"https:\/\/community.smartsheet.com\/discussion\/100641\/profile-pic-not-saving","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100641\/profile-pic-not-saving","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-03T16:43:16+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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":101754,"type":"question","name":"Simple CountIf","excerpt":"I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?","categoryID":322,"dateInserted":"2023-02-24T23:48:32+00:00","dateUpdated":null,"dateLastComment":"2023-02-25T16:34:55+00:00","insertUserID":139369,"insertUser":{"userID":139369,"name":"Cat.Cosby","url":"https:\/\/community.smartsheet.com\/profile\/Cat.Cosby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DA54FAXEIV61\/nVQNHQ6VMQVMD.png","dateLastActive":"2023-08-16T22:06:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":139369,"lastUser":{"userID":139369,"name":"Cat.Cosby","url":"https:\/\/community.smartsheet.com\/profile\/Cat.Cosby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DA54FAXEIV61\/nVQNHQ6VMQVMD.png","dateLastActive":"2023-08-16T22:06:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":96,"score":null,"hot":3354626607,"url":"https:\/\/community.smartsheet.com\/discussion\/101754\/simple-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101754\/simple-countif","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-25T16:34:09+00:00","dateAnswered":"2023-02-25T02:48:23+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":86473,"type":"question","name":"Formula Error","excerpt":"Hello, I was hoping to get some help with a formula. We are using INDEX\/MATCH. Its all working great when we are referencing one column. When we change the reference to select a range of columns, the formula doesn't work and we get #UNPERISHABLE. Can someone help us figure out how to reference a range of columns? Here is…","categoryID":322,"dateInserted":"2022-01-12T22:33:17+00:00","dateUpdated":null,"dateLastComment":"2022-01-12T22:52:52+00:00","insertUserID":139369,"insertUser":{"userID":139369,"name":"Cat.Cosby","url":"https:\/\/community.smartsheet.com\/profile\/Cat.Cosby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DA54FAXEIV61\/nVQNHQ6VMQVMD.png","dateLastActive":"2023-08-16T22:06:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":141976,"lastUser":{"userID":141976,"name":"Devin Lee","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Devin%20Lee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wuDav0gnudQ!HYnb31wbkr4!hoPeVxbhNwX","dateLastActive":"2023-07-31T21:45:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":65,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/86473\/formula-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86473\/formula-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-12T22:52:52+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":84288,"type":"question","name":"Does anyone know if its possibly to use INDEX MATCH to pull in images?","excerpt":"The formula seems to be working but it pulls in the PNG name and not the image. although the image name doesn't match. I am not sure what is going wrong. it looks like it is pulling in the name of the last icon image. Does anyone have any tips?","categoryID":322,"dateInserted":"2021-10-21T22:34:28+00:00","dateUpdated":null,"dateLastComment":"2021-10-22T07:03:56+00:00","insertUserID":139369,"insertUser":{"userID":139369,"name":"Cat.Cosby","url":"https:\/\/community.smartsheet.com\/profile\/Cat.Cosby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DA54FAXEIV61\/nVQNHQ6VMQVMD.png","dateLastActive":"2023-08-16T22:06:14+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":1,"countViews":150,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/84288\/does-anyone-know-if-its-possibly-to-use-index-match-to-pull-in-images","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84288\/does-anyone-know-if-its-possibly-to-use-index-match-to-pull-in-images","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/RXLON3EA3AC1\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-22T07:03:56+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":false,"noCheckboxes":true}">
