功能

=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…","categoryID":322,"dateInserted":"2022-09-16T19:27:43+00:00","dateUpdated":null,"dateLastComment":"2022-09-17T16:06:33+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2022-11-18T13:54:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2022-11-18T13:54:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":77,"score":null,"hot":3326789056,"url":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/K3KPF24CX85O\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-16T22:29:27+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"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":95088,"type":"question","name":"TASK % COMPLETE FORMULA","excerpt":"I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N\/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…","categoryID":322,"dateInserted":"2022-09-06T19:10:55+00:00","dateUpdated":"2022-09-15T20:12:14+00:00","dateLastComment":"2022-09-17T16:01:27+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2022-11-18T13:54:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2022-11-18T13:54:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":112,"score":null,"hot":3325926142,"url":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1SK8Y124XWFR\/image-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-06T19:50:58+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"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":95370,"type":"idea","name":"Group Columns in Grid","excerpt":"Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…","categoryID":349,"dateInserted":"2022-09-14T20:17:00+00:00","dateUpdated":null,"dateLastComment":"2022-09-16T18:18:29+00:00","insertUserID":113894,"insertUser":{"userID":113894,"name":"Laura Payne","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Payne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hdlbITHk9Tw!xnta8eHpOzQ!cFhmjtLaehI","dateLastActive":"2022-09-14T20:13:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":138105,"lastUser":{"userID":138105,"name":"Nik Fuentes","url":"https:\/\/community.smartsheet.com\/profile\/Nik%20Fuentes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2L6JP17FBEN7\/n3IWD70UPYLDQ.jpg","dateLastActive":"2022-11-02T15:26:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":52,"score":5,"hot":3326541029,"url":"https:\/\/community.smartsheet.com\/discussion\/95370\/group-columns-in-grid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95370\/group-columns-in-grid","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"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":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">