帮助我们了解什么是最重要的员工和客户重返工作岗位-采取快速调查!
类别
I hope you're well and safe!<\/p>
Unfortunately, it's not possible now, but it's an excellent idea!<\/p>
Please submit this as a Product Feedback or Idea <\/strong>(If it hasn't been added already)<\/em><\/strong> when you have a moment.<\/strong><\/a><\/p> I hope that helps!<\/p> Be safe and have a fantastic weekend!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-29 22:59:23","updateUser":{"userID":143245,"name":"WillieBNZ","url":"https:\/\/community.smartsheet.com\/profile\/WillieBNZ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-29T22:59:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":93766,"type":"question","name":"Nested IF with IFERROR","excerpt":"I have an IF statment that is working fine. But in many cases it is returning '#INVALID DATA TYPE'. When it returns that I would like the cell to be empty. How do \/where do I nest the IF with the IFERROR?","categoryID":321,"dateInserted":"2022-07-29T21:07:30+00:00","dateUpdated":null,"dateLastComment":"2022-07-29T21:24:38+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-29T21:22:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":147369,"lastUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-29T21:22:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3318259928,"url":"https:\/\/community.smartsheet.com\/discussion\/93766\/nested-if-with-iferror","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93766\/nested-if-with-iferror","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":93766,"commentID":338039,"name":"Re: Nested IF with IFERROR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338039#Comment_338039","dateInserted":"2022-07-29T21:24:38+00:00","insertUserID":147369,"insertUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-29T21:22:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/OYH1EAFHWCXF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-29T21:24:14+00:00","dateAnswered":"2022-07-29T21:16:50+00:00","acceptedAnswers":[{"commentID":338037,"body":" Hey @PeggyLane<\/p> =IFERROR(IF([Helper1 - Weekday = Monday?]@row = 2, \"//www.santa-greenland.com/community/discussion/69338/\", \"Red\"),\"//www.santa-greenland.com/community/discussion/69338/\")<\/p> Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-29 21:24:14","updateUser":{"userID":147369,"name":"PeggyLang","url":"https:\/\/community.smartsheet.com\/profile\/PeggyLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-29T21:22:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":93687,"type":"question","name":"Group function in reports is sorting alphabetically rather than by date sort","excerpt":"I have tasks with various dates within a given month. I'm wanting to group all tasks by Month so that I can see all tasks that fall into the respective month and group them in a report and have them sort by the month (Jan, Feb, Mer, etc.) However, SS is sorting by the month name (July, June, September, etc.) I found the…","categoryID":321,"dateInserted":"2022-07-28T13:39:25+00:00","dateUpdated":null,"dateLastComment":"2022-07-30T10:53:05+00:00","insertUserID":125814,"insertUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-07-30T10:53:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-07-31T13:15:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":20,"score":null,"hot":3318198150,"url":"https:\/\/community.smartsheet.com\/discussion\/93687\/group-function-in-reports-is-sorting-alphabetically-rather-than-by-date-sort","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93687\/group-function-in-reports-is-sorting-alphabetically-rather-than-by-date-sort","format":"Rich","lastPost":{"discussionID":93687,"commentID":338059,"name":"Re: Group function in reports is sorting alphabetically rather than by date sort","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338059#Comment_338059","dateInserted":"2022-07-30T10:53:05+00:00","insertUserID":8888,"insertUser":{"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-07-31T13:15:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-30T10:21:11+00:00","dateAnswered":"2022-07-30T09:52:25+00:00","acceptedAnswers":[{"commentID":338058,"body":" That worked! Thanks for your help!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-30 10:21:11","updateUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-07-30T10:53:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
