Doyle54✭✭✭✭✭

3), 2,…","categoryID":322,"dateInserted":"2020-10-07T17:15:58+00:00","dateUpdated":null,"dateLastComment":"2020-10-14T19:45:38+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":100191,"lastUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":93,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/71992\/summary-sheet-i-want-to-reference-other-calculations-in-sum-sheet-but-cannot-use-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71992\/summary-sheet-i-want-to-reference-other-calculations-in-sum-sheet-but-cannot-use-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":72213,"type":"question","name":"Referencing data in another sheet when other sheet is continually expanding in an IF(AND situation","excerpt":"Sorry if my question is too simple but this is an important bit of coding. I am referencing a continually expanding sheet what would be the coding like: Quarter1 is calculated in the Summary Sheet of the current sheet. Current Quarter1 is 04-2020. I want to check if a value in a pad in a sheet (Well Pad List) matches a pad…","categoryID":322,"dateInserted":"2020-10-14T14:49:28+00:00","dateUpdated":null,"dateLastComment":"2020-10-14T16:10:37+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":100191,"lastUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":61,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/72213\/referencing-data-in-another-sheet-when-other-sheet-is-continually-expanding-in-an-if-and-situation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72213\/referencing-data-in-another-sheet-when-other-sheet-is-continually-expanding-in-an-if-and-situation","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":72180,"type":"question","name":"I have an automatic date field. I cannot modify the date if it is the wrong date. Any suggestions?","excerpt":"I have an automatic date field. I cannot modify the date if it is the wrong date. Any suggestions?","categoryID":322,"dateInserted":"2020-10-13T16:42:51+00:00","dateUpdated":null,"dateLastComment":"2020-10-13T21:55:29+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":100191,"lastUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":63,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/72180\/i-have-an-automatic-date-field-i-cannot-modify-the-date-if-it-is-the-wrong-date-any-suggestions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72180\/i-have-an-automatic-date-field-i-cannot-modify-the-date-if-it-is-the-wrong-date-any-suggestions","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69902,"type":"question","name":"New row autofill","excerpt":"I want to autofill new rows with formulas that would execute as data is loaded into certain fields. Specifically, someone uses a form to start a new row. In the form there is a logic option but not a real conditional with a formula. It may not be available in the Form but what about the Sheet? There is languaging about two…","categoryID":322,"dateInserted":"2020-07-16T17:01:31+00:00","dateUpdated":null,"dateLastComment":"2020-08-20T09:40:39+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":100191,"lastUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":106,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/69902\/new-row-autofill","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69902\/new-row-autofill","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69766,"type":"question","name":"Help with Countifs - Summary Sheet","excerpt":"I am wanting to have a shared user be able to input a Startdate and EndDate which is then calculated using Countifs. Is this possible in a Summary Sheet? I get an unparseable error for the code below. Any suggestions? Thanks. c","categoryID":322,"dateInserted":"2020-07-10T15:42:35+00:00","dateUpdated":null,"dateLastComment":"2020-07-10T17:03:09+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+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":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69766\/help-with-countifs-summary-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69766\/help-with-countifs-summary-sheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FMEXFGYRIF2M\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69704,"type":"question","name":"Fields are Missing in Form Logic Construction","excerpt":"What I am trying to do is use Logic to select a Company and use that Selection go to a specific Company Field. There is a Dropdown for the Company Selection - (like BR on left) and another for the Company (like BR Field) that allows the user to select the specific pad he is inspecting. The logic process is straightforward…","categoryID":322,"dateInserted":"2020-07-08T21:05:09+00:00","dateUpdated":null,"dateLastComment":"2020-07-08T21:20:22+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":100191,"lastUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":196,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69704\/fields-are-missing-in-form-logic-construction","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69704\/fields-are-missing-in-form-logic-construction","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JXC44LICXFOH\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":69429,"type":"question","name":"Simple If with @row - Why won't this work?","excerpt":"","categoryID":322,"dateInserted":"2020-06-25T22:44:00+00:00","dateUpdated":null,"dateLastComment":"2020-07-08T10:59:12+00:00","insertUserID":100191,"insertUser":{"userID":100191,"name":"Doyle54","url":"https:\/\/community.smartsheet.com\/profile\/Doyle54","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x8FFMecnnPo!bOjCm8kQSFY!5coFfTEIyy9","dateLastActive":"2020-10-30T14:29:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":107,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/69429\/simple-if-with-row-why-wont-this-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69429\/simple-if-with-row-why-wont-this-work","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/WDJOA3OH5B7J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":false,"noCheckboxes":true}">