建设

\"No\", @cell <> \"Complete\"), {(Phoenix) Project Tracker - Status column}, AND(@cell = \"Complete\"), {(Phoenix) Project Tracker -…","categoryID":322,"dateInserted":"2021-06-20T03:22:58+00:00","dateUpdated":null,"dateLastComment":"2021-06-20T19:54:14+00:00","insertUserID":137250,"insertUser":{"userID":137250,"name":"Megan Kauffman","url":"https:\/\/community.smartsheet.com\/profile\/Megan%20Kauffman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-29T19:44:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-09-02T15:05:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/80519\/how-to-create-this-countifs-with-and-or-not","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/80519\/how-to-create-this-countifs-with-and-or-not","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-06-20T19:54:14+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":218,"urlcode":"Construction","name":"Construction"},{"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":70746,"type":"question","name":"One off Saturdays in Gantt","excerpt":"Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?","categoryID":321,"dateInserted":"2020-08-20T17:41:31+00:00","dateUpdated":null,"dateLastComment":"2021-06-18T21:45:02+00:00","insertUserID":121091,"insertUser":{"userID":121091,"name":"Molly Hanson","url":"https:\/\/community.smartsheet.com\/profile\/Molly%20Hanson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GjK9vay6CSPLUL-bpO6g016cIhjtH7N9-zCWzsYUQ=s96-c","dateLastActive":"2021-01-27T12:26:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137234,"lastUser":{"userID":137234,"name":"Austin Clos","url":"https:\/\/community.smartsheet.com\/profile\/Austin%20Clos","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pM1Y6UG-p6Q!umDfd2hLkmQ!Pz5OqgcliFB","dateLastActive":"2021-07-10T16:21:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":18,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70746\/one-off-saturdays-in-gantt","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70746\/one-off-saturdays-in-gantt","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-08-20T23:18:47+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}">