探索。问。的答案。

3, IFERROR(MONTH(@cell), 0) <= 6), {Grad Date},…","categoryID":322,"dateInserted":"2022-07-18T16:20:21+00:00","dateUpdated":"2022-07-18T16:27:32+00:00","dateLastComment":"2022-07-18T20:49:52+00:00","insertUserID":124874,"insertUser":{"userID":124874,"name":"Marie Toft","url":"https:\/\/community.smartsheet.com\/profile\/Marie%20Toft","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w-vV_z9NgL4!prjVqW91vCY!W69qx5tLe5u","dateLastActive":"2022-08-01T19:26:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":124874,"lastUser":{"userID":124874,"name":"Marie Toft","url":"https:\/\/community.smartsheet.com\/profile\/Marie%20Toft","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w-vV_z9NgL4!prjVqW91vCY!W69qx5tLe5u","dateLastActive":"2022-08-01T19:26:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":3316339813,"url":"https:\/\/community.smartsheet.com\/discussion\/93305\/formula-countifs-and-date-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93305\/formula-countifs-and-date-help","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-19T02:38:09+00:00","dateAnswered":"2022-07-18T20:49: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":[],"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":93327,"type":"question","name":"Sum Children not working","excerpt":"I cannot get the parent row to sum anything except direct children. If them children have children, it is not including this in the sum (see screenshot).","categoryID":322,"dateInserted":"2022-07-18T20:16:36+00:00","dateUpdated":"2022-07-18T21:00:23+00:00","dateLastComment":"2022-07-18T20:49:43+00:00","insertUserID":147491,"insertUser":{"userID":147491,"name":"Kristin Fortner","url":"https:\/\/community.smartsheet.com\/profile\/Kristin%20Fortner","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucrSmRsnJftY2q83EhRpCJoicmrAsrb6D_iCZdSJ=s96-c","dateLastActive":"2022-08-05T19:37:47+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":3,"countViews":3,"score":null,"hot":3316354579,"url":"https:\/\/community.smartsheet.com\/discussion\/93327\/sum-children-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93327\/sum-children-not-working","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-18T20:43:52+00:00","dateAnswered":"2022-07-18T20:38:47+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":92753,"type":"idea","name":"Right click on Widgets to copy into Emails\/Word etc","excerpt":"Dashboards create some useful graphs and tables. Sometimes we need to communicate the graphs\/tables in emails or in documents\/reports. It would be very handy to be able to right-click on a dashboard widget, select copy, and then paste into other software. Currently, I use the Snip tool in Windows which is not always…","categoryID":349,"dateInserted":"2022-06-29T01:28:05+00:00","dateUpdated":"2022-06-30T13:35:41+00:00","dateLastComment":"2022-07-18T20:49:30+00:00","insertUserID":87801,"insertUser":{"userID":87801,"name":"Richard Heath","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Heath","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PQ5MK3GA3T0T\/nRH0VLM6IQ91L.jpg","dateLastActive":"2022-08-05T04:39:41+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":7,"countViews":56,"score":5,"hot":3314649155,"url":"https:\/\/community.smartsheet.com\/discussion\/92753\/right-click-on-widgets-to-copy-into-emails-word-etc","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92753\/right-click-on-widgets-to-copy-into-emails-word-etc","format":"Rich","groupID":null,"statusID":0,"attributes":{"idea":{"statusNotes":"This idea has an invalid status.","statusID":0,"status":{"name":"Invalid","state":"open"},"type":"up-down"}},"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":292,"urlcode":"Dashboards","name":"Dashboards"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93306,"type":"question","name":"IF formula #Unparseable error","excerpt":"Hello! I have set up the following IF formula that triggers actions based on risk category, but it is returning an #Unparseable error. I would appreciate any help anyone can provide. Thanks! =IF(CATEGORY@row = “Resource”, “Escalate”, “Do not escalate”)","categoryID":322,"dateInserted":"2022-07-18T16:38:42+00:00","dateUpdated":"2022-07-18T16:59:19+00:00","dateLastComment":"2022-07-18T20:34:05+00:00","insertUserID":150188,"insertUser":{"userID":150188,"name":"PSuazo","url":"https:\/\/community.smartsheet.com\/profile\/PSuazo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-25T20:45:15+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":3,"countViews":4,"score":null,"hot":3316340567,"url":"https:\/\/community.smartsheet.com\/discussion\/93306\/if-formula-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93306\/if-formula-unparseable-error","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-18T18:11:40+00:00","dateAnswered":"2022-07-18T17:05:00+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":228,"urlcode":"Project Management","name":"Project Management"},{"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":76100,"type":"question","name":"How can I add a Phone Number to My Contacts?","excerpt":"How can I add a Phone Number to My Contacts? I want to add phone numbers to My Contacts in addition to the name and email.","categoryID":321,"dateInserted":"2021-02-11T23:00:16+00:00","dateUpdated":null,"dateLastComment":"2022-07-18T20:29:19+00:00","insertUserID":131943,"insertUser":{"userID":131943,"name":"Mark Burlingame","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Burlingame","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-12T19:30:36+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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":147,"score":null,"hot":3271264175,"url":"https:\/\/community.smartsheet.com\/discussion\/76100\/how-can-i-add-a-phone-number-to-my-contacts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76100\/how-can-i-add-a-phone-number-to-my-contacts","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-12T19:30:41+00:00","dateAnswered":"2021-02-12T17:44:27+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":247,"urlcode":"Contacts","name":"Contacts"}],"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":93115,"type":"question","name":"How to use Smartsheet's legacy resource management function to highlight conflicts and auto change","excerpt":"Hello, apologies in advance if this appears to be a rather basic enquiry, however, I'm not familiar with Smartsheet's legacy resource mangagement tool. I've had an enquiry from a colleague who has a Gantt chart sheet showing his team's tasks (as below). He's wanting the sheet to be able to add holidays for people and for…","categoryID":321,"dateInserted":"2022-07-12T11:50:20+00:00","dateUpdated":"2022-07-18T20:30:40+00:00","dateLastComment":"2022-07-18T20:27:06+00:00","insertUserID":78206,"insertUser":{"userID":78206,"name":"SteCoxy","url":"https:\/\/community.smartsheet.com\/profile\/SteCoxy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTDbGqngcGQ!2wnbf5m83zw!VTDReGCjYpc","dateLastActive":"2022-07-18T09:40:45+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":36,"score":null,"hot":3315803846,"url":"https:\/\/community.smartsheet.com\/discussion\/93115\/how-to-use-smartsheets-legacy-resource-management-function-to-highlight-conflicts-and-auto-change","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93115\/how-to-use-smartsheets-legacy-resource-management-function-to-highlight-conflicts-and-auto-change","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T20:27:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":93262,"type":"question","name":"Cross sheet formula","excerpt":"I am new to Smartsheet and am struggling with a basic formula. I am simply trying to multiply a value from in a specific cell from one sheet with a value in a specific cell from another sheet. I have been able to get a result by using this formula. =$[2021 WP Year-End Forecast]1 * ({Project Costs - Cost - Labor OT…","categoryID":322,"dateInserted":"2022-07-15T15:33:18+00:00","dateUpdated":null,"dateLastComment":"2022-07-18T20:25:09+00:00","insertUserID":150154,"insertUser":{"userID":150154,"name":"Jim Lorch","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Lorch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T20:57:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150154,"lastUser":{"userID":150154,"name":"Jim Lorch","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Lorch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T20:57:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":1,"hot":3316076607,"url":"https:\/\/community.smartsheet.com\/discussion\/93262\/cross-sheet-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93262\/cross-sheet-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-18T20:26:28+00:00","dateAnswered":"2022-07-18T20:25:09+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":93269,"type":"question","name":"Control Center: Global Update Column with different Row Formulas","excerpt":"I have created a Sheet that has different formulas by row and not one consistent Column Formula. I have saved this as part of the blueprint template. And now I want to add a few columns that show the % mix of different categories. (see image below) To update already provisioned projects, is there a way to do this through a…","categoryID":322,"dateInserted":"2022-07-15T18:16:52+00:00","dateUpdated":null,"dateLastComment":"2022-07-18T20:19:11+00:00","insertUserID":124874,"insertUser":{"userID":124874,"name":"Marie Toft","url":"https:\/\/community.smartsheet.com\/profile\/Marie%20Toft","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w-vV_z9NgL4!prjVqW91vCY!W69qx5tLe5u","dateLastActive":"2022-08-01T19:26:49+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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":23,"score":null,"hot":3316086963,"url":"https:\/\/community.smartsheet.com\/discussion\/93269\/control-center-global-update-column-with-different-row-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93269\/control-center-global-update-column-with-different-row-formulas","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VIVKZ3GWSHJ5\/summary-of-diversity-metrics-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Summary of Diversity Metrics.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-18T18:39:33+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":true,"noCheckboxes":false}">