Discussions
\"\"), 1))","categoryID":322,"dateInserted":"2022-08-04T20:18:04+00:00","dateUpdated":null,"dateLastComment":"2022-08-08T20:12:13+00:00","insertUserID":150427,"insertUser":{"userID":150427,"name":"SEBERCAW","url":"https:\/\/community.smartsheet.com\/profile\/SEBERCAW","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpba5VVBAHyaGW4Sjhx0LlZJJH1Otj6Fsbq5h6BAw=s96-c","dateLastActive":"2022-08-20T16:50:51+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-06-09T14:12:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":96,"score":null,"hot":3319635617,"url":"https:\/\/community.smartsheet.com\/discussion\/93953\/help-with-iferror","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93953\/help-with-iferror","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-15T11:23:24+00:00","dateAnswered":"2022-08-04T21:09:15+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":93476,"type":"question","name":"Update a Column on Employee Sheet from another Answer Form sheet","excerpt":"I am very new to Smartsheet. I created a form that has Employee Names and columns of different types of Safety Credentials. I then created a new \"Answer\" sheet that is linked to a form. When the \"Answer\" sheet is updated with the date of a credential, I want to do two things. Update the corresponding column in the Employee…","categoryID":322,"dateInserted":"2022-07-21T18:33:34+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T13:13:52+00:00","insertUserID":150427,"insertUser":{"userID":150427,"name":"SEBERCAW","url":"https:\/\/community.smartsheet.com\/profile\/SEBERCAW","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpba5VVBAHyaGW4Sjhx0LlZJJH1Otj6Fsbq5h6BAw=s96-c","dateLastActive":"2022-08-20T16:50:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150427,"lastUser":{"userID":150427,"name":"SEBERCAW","url":"https:\/\/community.smartsheet.com\/profile\/SEBERCAW","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpba5VVBAHyaGW4Sjhx0LlZJJH1Otj6Fsbq5h6BAw=s96-c","dateLastActive":"2022-08-20T16:50:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":144,"score":null,"hot":3318137846,"url":"https:\/\/community.smartsheet.com\/discussion\/93476\/update-a-column-on-employee-sheet-from-another-answer-form-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93476\/update-a-column-on-employee-sheet-from-another-answer-form-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-30T13:34:49+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}">