探索。问。的答案。

\"\", [approval actual]@row, IF([approval predicted]@row <>\"\", [approval predicted]@row, [approval revised]@row)) With the addition of the approval column I'm not quite sure, it tried some…","categoryID":322,"dateInserted":"2022-07-08T16:03:48+00:00","dateUpdated":"2022-07-18T16:26:14+00:00","dateLastComment":"2022-07-18T16:19:29+00:00","insertUserID":135253,"insertUser":{"userID":135253,"name":"Mike DeLuca","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20DeLuca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DJX8MT8AHAOG\/n414M0QWWY7XF.jpg","dateLastActive":"2022-07-14T05:55:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-08-05T02:13:16+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":53,"score":null,"hot":3315458597,"url":"https:\/\/community.smartsheet.com\/discussion\/93050\/cell-selection-one-cell-over-another-with-increasing-decreasing-dates-and-blank-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93050\/cell-selection-one-cell-over-another-with-increasing-decreasing-dates-and-blank-cells","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MH1QBDE5IYUB\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T16:03: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}]},{"discussionID":93304,"type":"idea","name":"Pinned Comments & Signatures on forms","excerpt":"It would be amazing if we could pin comments to the top of the 'comment list' for lack of a better word. For our industry we track additional work requested. We have a form - but our field operations find sometimes its hard to stop mid job to fill one out but if they could go into the comments box to a pinned 'Extras'…","categoryID":349,"dateInserted":"2022-07-18T16:16:25+00:00","dateUpdated":null,"dateLastComment":"2022-07-18T16:16:25+00:00","insertUserID":146577,"insertUser":{"userID":146577,"name":"Maryah ","url":"https:\/\/community.smartsheet.com\/profile\/Maryah%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-18T16:11:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146577,"lastUser":{"userID":146577,"name":"Maryah ","url":"https:\/\/community.smartsheet.com\/profile\/Maryah%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-18T16:11:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/93304\/pinned-comments-signatures-on-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93304\/pinned-comments-signatures-on-forms","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":1,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":456,"urlcode":"","name":"(Untitled)"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93119,"type":"question","name":"Help with Date Auto-Populate, Countifs & Reporting","excerpt":"Hi Team, I hope everyone is well! My name is Patrick and I'm a new SS user and was wondering if I can ask for help with the following: 1 Auto-populate the date if columns Agent and Ticket# are filled in. 2 Countifs formula is not capturing 07\/11 3 Chart Reporting date to auto-change weekly based on next week's dates Please…","categoryID":322,"dateInserted":"2022-07-12T14:06:26+00:00","dateUpdated":"2022-07-18T16:27:52+00:00","dateLastComment":"2022-07-18T16:15:01+00:00","insertUserID":149982,"insertUser":{"userID":149982,"name":"virtualfreelance","url":"https:\/\/community.smartsheet.com\/profile\/virtualfreelance","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJwY-hJy5-5-kUKpkllzJKFvTyrmSQIWbbJ5UzpS=s96-c","dateLastActive":"2022-07-18T20:53:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-08-05T02:13:16+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":35,"score":null,"hot":3315796287,"url":"https:\/\/community.smartsheet.com\/discussion\/93119\/help-with-date-auto-populate-countifs-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93119\/help-with-date-auto-populate-countifs-reporting","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T16:15:01+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":93194,"type":"discussion","name":"NEW: Submit offline forms on mobile","excerpt":"Hi Community, Have you ever tried to submit a form on the Smartsheet mobile app, only to realize you had no internet connection? Whether submitting expenses on a plane or safety inspections on an oil rig, you need the ability to capture information anywhere! Now, the Smartsheet mobile app allows users to mark a form…","categoryID":335,"dateInserted":"2022-07-13T19:08:48+00:00","dateUpdated":"2022-07-25T14:19:32+00:00","dateLastComment":"2022-07-18T16:01:43+00:00","insertUserID":145085,"insertUser":{"userID":145085,"name":"Allegra Silcox","url":"https:\/\/community.smartsheet.com\/profile\/Allegra%20Silcox","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!btnWmx2hXT4!nevWPz3DEL4!dfcwT6jINFw","dateLastActive":"2022-08-04T22:00:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":124375,"lastUserID":65666,"lastUser":{"userID":65666,"name":"Nick Burrus","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Burrus","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/96\/c3\/n96c3f5b3cc2da8516071bbb72fe405b6.JPG","dateLastActive":"2022-08-05T22:09:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":106,"score":3,"hot":3315900931,"url":"https:\/\/community.smartsheet.com\/discussion\/93194\/new-submit-offline-forms-on-mobile","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93194\/new-submit-offline-forms-on-mobile","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/7KKQKLCMHW89\/57582-mobile-offline-forms-email-image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"57582-mobile-offline-forms-email-image.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":246,"urlcode":"Mobile","name":"Mobile"}],"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":93170,"type":"question","name":"Language options for Portals & Forms","excerpt":"Hi, I'm looking for options to create a portal in Arabic and also forms in Arabic. Is this possible currently with smartsheet or smartsheet add-ons? Many thanks!","categoryID":343,"dateInserted":"2022-07-13T11:24:03+00:00","dateUpdated":"2022-07-14T15:05:46+00:00","dateLastComment":"2022-07-18T15:57:11+00:00","insertUserID":147984,"insertUser":{"userID":147984,"name":"Bridey Watson","url":"https:\/\/community.smartsheet.com\/profile\/Bridey%20Watson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!e4VaJwQ9IwU!ZtlYGaCtfbs!sgmteCe_R5F","dateLastActive":"2022-07-29T11:12:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3315871874,"url":"https:\/\/community.smartsheet.com\/discussion\/93170\/language-options-for-portals-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93170\/language-options-for-portals-forms","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T15:57:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":93016,"type":"question","name":"Python API - How do I transfer a date-time value from a Pandas data frame to a new row?","excerpt":"Hi! This is my first question in the forum, so please let me know if I'm doing something wrong. I have some data in an excel csv file, and I have copied it into a Pandas data frame. One of the fields in the csv has this format: \"3\/17\/2022 10:59:00 AM\" and when transferred to the data frame it shows '3\/17\/2022 10:59'. So I…","categoryID":320,"dateInserted":"2022-07-07T17:10:07+00:00","dateUpdated":"2022-07-18T15:51:01+00:00","dateLastComment":"2022-07-18T15:49:21+00:00","insertUserID":149838,"insertUser":{"userID":149838,"name":"jzinna","url":"https:\/\/community.smartsheet.com\/profile\/jzinna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-01T18:04:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-08-05T02:13:16+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3315373768,"url":"https:\/\/community.smartsheet.com\/discussion\/93016\/python-api-how-do-i-transfer-a-date-time-value-from-a-pandas-data-frame-to-a-new-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93016\/python-api-how-do-i-transfer-a-date-time-value-from-a-pandas-data-frame-to-a-new-row","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T15:49:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"}],"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}">