公式

1, 1, 0) is the formula I'm currently using but I want to have it setup as a column…","categoryID":322,"dateInserted":"2022-08-19T20:36:52+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T16:41:06+00:00","insertUserID":149834,"insertUser":{"userID":149834,"name":"Sarah123","url":"https:\/\/community.smartsheet.com\/profile\/Sarah123","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pz9CadKbo_o!29DB_y7O5eQ!floqOYAlioC","dateLastActive":"2022-10-21T15:24:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151835,"lastUser":{"userID":151835,"name":"compartido.tactic","url":"https:\/\/community.smartsheet.com\/profile\/compartido.tactic","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xzFesXaX4Po!DP9Qw9Sqwfo!PdLZCHwrMrk","dateLastActive":"2022-10-21T17:49:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":65,"score":null,"hot":3327314878,"url":"https:\/\/community.smartsheet.com\/discussion\/94490\/duplicate-row-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94490\/duplicate-row-column-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-22T13:57:28+00:00","dateAnswered":"2022-08-20T03:19:25+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":65020,"type":"question","name":"Creating a IF(AND(ISDATE formula to check a box","excerpt":"Hi All, I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts. Goal: in my data set I dont care what the date is just that it is a date (anydate)…","categoryID":322,"dateInserted":"2020-01-03T18:45:02+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T15:19:12+00:00","insertUserID":89201,"insertUser":{"userID":89201,"name":"latheobald89201","url":"https:\/\/community.smartsheet.com\/profile\/latheobald89201","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgT6W-yCxah_t38m3GVCeEi-RFa0JdrnfO65pAoeA=s96-c","dateLastActive":"2022-10-21T15:58:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":613,"score":null,"hot":3244447454,"url":"https:\/\/community.smartsheet.com\/discussion\/65020\/creating-a-if-and-isdate-formula-to-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65020\/creating-a-if-and-isdate-formula-to-check-a-box","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-01-08T00:10:47+00:00","dateAnswered":"2020-01-06T13:02: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":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":96639,"type":"question","name":"Creating a formula to track number of days but with a catch","excerpt":"So I have been tasked with creating a formula that tracks the number of days an element is \"No\". However, there are multiple forms submitted each day so I do not want to count the number of times a \"No\" is selected. It needs to be a formula that counts the consecutive days but then resets to 0 if the element has a \"Yes\"…","categoryID":322,"dateInserted":"2022-10-16T14:55:13+00:00","dateUpdated":"2022-10-17T08:11:51+00:00","dateLastComment":"2022-10-21T15:07:47+00:00","insertUserID":152523,"insertUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T01:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":29,"score":null,"hot":3332298780,"url":"https:\/\/community.smartsheet.com\/discussion\/96639\/creating-a-formula-to-track-number-of-days-but-with-a-catch","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96639\/creating-a-formula-to-track-number-of-days-but-with-a-catch","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LSJY3WASUDC2\/smartsheet-forum-7.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet forum 7.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-17T13:42:36+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":96716,"type":"question","name":"Convert decimals (fractions) to hours and minutes","excerpt":"Can anyone provide a simple formula to convert decimals\/fractions to hours and minutes?","categoryID":322,"dateInserted":"2022-10-18T10:10:53+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T15:06:24+00:00","insertUserID":50121,"insertUser":{"userID":50121,"name":"TeeM","url":"https:\/\/community.smartsheet.com\/profile\/TeeM","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvjAJ2oCliY!!vo_hC89_e4s","dateLastActive":"2022-10-21T22:09:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":36,"score":null,"hot":3332456237,"url":"https:\/\/community.smartsheet.com\/discussion\/96716\/convert-decimals-fractions-to-hours-and-minutes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96716\/convert-decimals-fractions-to-hours-and-minutes","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-18T15:31:12+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">