Discussions
\"Contacted - Need to Follow up\", \"green\", IF(AND([Attempt #]@row <= 2, \"green\",…","categoryID":322,"dateInserted":"2023-10-16T21:34:46+00:00","dateUpdated":"2023-10-16T21:40:46+00:00","dateLastComment":"2023-10-17T01:41:03+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ydtrMjfn7jo!Hrjonx_TnCo!X4XBqU0zY2F","dateLastActive":"2023-10-17T13:16:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162062,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-10-27T01:54:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":48,"score":null,"hot":3395001949,"url":"https:\/\/community.smartsheet.com\/discussion\/111736\/if-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111736\/if-and","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-10-17T00:36:45+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":[],"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":107138,"type":"question","name":"Smartsheet to allow for multiple updates to a line","excerpt":"Hi there, I am looking for a way to be able to have our employees update a single line each time they reach out to a person with the date they reached out and any notes. They may reach out multiple times in a months time, just not for sure how many time. For example: We have a ton of clients. Hospital X: Reached out on…","categoryID":321,"dateInserted":"2023-06-30T14:15:20+00:00","dateUpdated":null,"dateLastComment":"2023-07-10T12:04:21+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ydtrMjfn7jo!Hrjonx_TnCo!X4XBqU0zY2F","dateLastActive":"2023-10-17T13:16:18+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-10-26T23:13:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":110,"score":null,"hot":3377128781,"url":"https:\/\/community.smartsheet.com\/discussion\/107138\/smartsheet-to-allow-for-multiple-updates-to-a-line","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107138\/smartsheet-to-allow-for-multiple-updates-to-a-line","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUZCY2JM2KGA\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-07-03T13:14:21+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":106700,"type":"question","name":"If Or Formula Help","excerpt":"My formula is working in Excel, but not in Smartsheet. I am still fairly new to smartsheet so any help would be appreciated. Basically its looking at the GLAcct column and find certain values and creating key terms for those values. Ex: If GLAcct = 710111 or 710121, then show Key Salary.","categoryID":322,"dateInserted":"2023-06-21T15:12:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T17:02:32+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ydtrMjfn7jo!Hrjonx_TnCo!X4XBqU0zY2F","dateLastActive":"2023-10-17T13:16:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162062,"lastUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ydtrMjfn7jo!Hrjonx_TnCo!X4XBqU0zY2F","dateLastActive":"2023-10-17T13:16:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":68,"score":null,"hot":3374728518,"url":"https:\/\/community.smartsheet.com\/discussion\/106700\/if-or-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106700\/if-or-formula-help","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/WU7DXUC1MGJ2\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T18:54:42+00:00","dateAnswered":"2023-06-21T15:29:14+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":[],"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":106008,"type":"question","name":"Smartsheet Formula Reference to another sheet","excerpt":"I am creating several different budget sheets. In these I want to reference one reference sheet. For example in my current sheet: I am looking to say If Column names: HI Rate Code = HR Rate Code from sheet name: Reference Guide then bring over the # listed in Sheet Name Reference Guide, Column Name: HI Rate Amount. Help :(","categoryID":322,"dateInserted":"2023-06-05T14:30:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T14:35:56+00:00","insertUserID":162062,"insertUser":{"userID":162062,"name":"mragans23","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/mragans23","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ydtrMjfn7jo!Hrjonx_TnCo!X4XBqU0zY2F","dateLastActive":"2023-10-17T13:16:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159376,"lastUser":{"userID":159376,"name":"Brad Schutts","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Schutts","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-17T15:55:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":34,"score":null,"hot":3371951796,"url":"https:\/\/community.smartsheet.com\/discussion\/106008\/smartsheet-formula-reference-to-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106008\/smartsheet-formula-reference-to-another-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-05T14:35: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":[],"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}">
