支持

=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = \"\") I am trying to create a COUNTIFS formula for each…","categoryID":322,"dateInserted":"2023-05-23T13:43:46+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T13:33:43+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T19:44:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T19:44:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":100,"score":null,"hot":3369875849,"url":"https:\/\/community.smartsheet.com\/discussion\/105579\/what-is-wrong-with-this-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105579\/what-is-wrong-with-this-countifs-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-23T17:45:53+00:00","dateAnswered":"2023-05-23T15:11:01+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":105644,"type":"question","name":".pdf no longer open in a new browser tab","excerpt":"Up until today a .pdf attachment in Smartsheets would open in a new browser tab. Today, a .pdf attachment will only open as a preview. We have tried in both Chrome and Edge with the same results. How do we fix this, so that when we open a .pdf attachment it defaults to opening in a new browser tab as opposed to the default…","categoryID":322,"dateInserted":"2023-05-24T14:28:15+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T12:28:25+00:00","insertUserID":161747,"insertUser":{"userID":161747,"name":"Mfloyd","url":"https:\/\/community.smartsheet.com\/profile\/Mfloyd","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-24T14:28:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":69,"score":null,"hot":3369957400,"url":"https:\/\/community.smartsheet.com\/discussion\/105644\/pdf-no-longer-open-in-a-new-browser-tab","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105644\/pdf-no-longer-open-in-a-new-browser-tab","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T14:41: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":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":105668,"type":"question","name":"Weekly Count","excerpt":"I need to count values weekly that don't have dates. I need to see progression weekly of how many still remain\/left. We have data that's when it's completed it'll remove from the sheet. Needs assistant!","categoryID":322,"dateInserted":"2023-05-24T20:17:46+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T20:28:09+00:00","insertUserID":161769,"insertUser":{"userID":161769,"name":"valenzuelat","title":"Admin","url":"https:\/\/community.smartsheet.com\/profile\/valenzuelat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T23:17:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T12:43:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":null,"hot":3369920155,"url":"https:\/\/community.smartsheet.com\/discussion\/105668\/weekly-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105668\/weekly-count","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T20:28: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":281,"urlcode":"Support","name":"Support"}],"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":105667,"type":"question","name":"I´ve a sheet with a column that describes the date that I would like to receive an alert, by e-mail.","excerpt":"How can I automate this? Thanks for help.","categoryID":321,"dateInserted":"2023-05-24T19:52:05+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T19:56:48+00:00","insertUserID":161768,"insertUser":{"userID":161768,"name":"Evelise Fonseca","title":"Ms","url":"https:\/\/community.smartsheet.com\/profile\/Evelise%20Fonseca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-24T20:00:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T12:43:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":null,"hot":3369916733,"url":"https:\/\/community.smartsheet.com\/discussion\/105667\/i-ve-a-sheet-with-a-column-that-describes-the-date-that-i-would-like-to-receive-an-alert-by-e-mail","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105667\/i-ve-a-sheet-with-a-column-that-describes-the-date-that-i-would-like-to-receive-an-alert-by-e-mail","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-24T19:56:48+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":281,"urlcode":"Support","name":"Support"}],"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":105656,"type":"question","name":"Core Product Certification Resources","excerpt":"Are there classes, tutorials or resources available for the core product certification that come as a course? Or do you just \"study\" on your own and then sign up and take the exam when you are ready? I am new to Smartsheet but would like to be certified. Thanks!","categoryID":346,"dateInserted":"2023-05-24T17:26:42+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T18:33:19+00:00","insertUserID":159810,"insertUser":{"userID":159810,"name":"aaniwa","url":"https:\/\/community.smartsheet.com\/profile\/aaniwa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T15:17:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145282,"lastUser":{"userID":145282,"name":"Matthew_Lanterman","url":"https:\/\/community.smartsheet.com\/profile\/Matthew_Lanterman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ABTW75W6Q0YM\/nCZGDXIPAAW6E.jpg","dateLastActive":"2023-06-06T17:57:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":43,"score":null,"hot":3369903001,"url":"https:\/\/community.smartsheet.com\/discussion\/105656\/core-product-certification-resources","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105656\/core-product-certification-resources","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T15:17:35+00:00","dateAnswered":"2023-05-24T18:33:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":346,"name":"Show & Tell","url":"https:\/\/community.smartsheet.com\/categories\/show-%26-tell","allowedDiscussionTypes":[]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":495,"urlcode":"smartsheet-certification","name":"Smartsheet Certification"}],"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":105572,"type":"idea","name":"Canada in Form Phone Validation","excerpt":"Greetings, Field Settings - Validation - Phone. If you select Canada and save it. The form will display the United States. I went back into settings to double-check the settings were still set to Canada, while the manage form view displayed the United States. Ultimately, my goal is to automate a dropdown with logic that…","categoryID":349,"dateInserted":"2023-05-23T07:59:56+00:00","dateUpdated":"2023-05-23T09:07:21+00:00","dateLastComment":"2023-05-24T18:14:19+00:00","insertUserID":161699,"insertUser":{"userID":161699,"name":"Vince_718","title":"Global Director of Client Success","url":"https:\/\/community.smartsheet.com\/profile\/Vince_718","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZqLRnY_XHz1XTyX6INRItJicmRaGjOMrvER3te-Q=s96-c","dateLastActive":"2023-06-02T02:05:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161699,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":64,"score":2,"hot":3369783855,"url":"https:\/\/community.smartsheet.com\/discussion\/105572\/canada-in-form-phone-validation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105572\/canada-in-form-phone-validation","format":"Rich","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/U1E4Q6DZJZN0\/smartsheet-country-glitch-with-canada.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet_country glitch with Canada.png"},"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":204,"urlcode":"Forms","name":"Forms"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":97274,"type":"discussion","name":"The Smartsheet Customer Support Portal is HERE!","excerpt":"Hi Community, We are excited to announce the new Customer Support Portal. Now, you will have one location to open support cases, provide additional information to your support case, and track your support cases until closed. The portal also includes a search function so that you can search for knowledge articles related to…","categoryID":2,"dateInserted":"2022-11-02T18:07:51+00:00","dateUpdated":"2023-02-22T18:37:39+00:00","dateLastComment":"2023-05-24T14:15:27+00:00","insertUserID":141931,"insertUser":{"userID":141931,"name":"Shawn M.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20M.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nmlpv1OHFbs!aSdqmnP9cDs!kg0ILMKuGOx","dateLastActive":"2023-06-02T19:16:26+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":126614,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":2071,"score":11,"hot":3352360698,"url":"https:\/\/community.smartsheet.com\/discussion\/97274\/the-smartsheet-customer-support-portal-is-here","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97274\/the-smartsheet-customer-support-portal-is-here","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":2,"name":"General Announcements","url":"https:\/\/community.smartsheet.com\/categories\/announcement","allowedDiscussionTypes":[]},"tags":[{"tagID":281,"urlcode":"Support","name":"Support"}],"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":105406,"type":"question","name":"Column erroneously dragging over into reports","excerpt":"I am experiencing an issue wherein an unwanted column of data is automatically being included in reports linked to a specific sheet. When I create the report and link this specific sheet, the reports are automatically inserting the unwanted column of data. The unwanted column is not listed under the column dropdown and…","categoryID":321,"dateInserted":"2023-05-18T12:23:37+00:00","dateUpdated":null,"dateLastComment":"2023-05-19T09:15:34+00:00","insertUserID":161575,"insertUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T08:37:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161575,"lastUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T08:37:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":64,"score":null,"hot":3368903351,"url":"https:\/\/community.smartsheet.com\/discussion\/105406\/column-erroneously-dragging-over-into-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105406\/column-erroneously-dragging-over-into-reports","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TOP97YKUE3YH\/screenshot-2023-05-18-132304.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-05-18 132304.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-18T12:26:48+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":281,"urlcode":"Support","name":"Support"}],"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":105374,"type":"question","name":"Form logic is not working","excerpt":"I submitted to tech support 5 days ago when discovered this and still can't get answers. I have built many many forms in the past however the logic is now not working. I dumped the form and started fresh however still has same issue. Logic is that when customer name is blank only Lot-Unit-Development should show however as…","categoryID":321,"dateInserted":"2023-05-17T20:14:26+00:00","dateUpdated":"2023-05-18T14:33:44+00:00","dateLastComment":"2023-05-18T14:32:36+00:00","insertUserID":161557,"insertUser":{"userID":161557,"name":"Oh Canada","url":"https:\/\/community.smartsheet.com\/profile\/Oh%20Canada","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!c2dcZ0bY-jo!c4nfx96Owz4!nyQqbzOnPkP","dateLastActive":"2023-05-18T14:08:55+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":"2023-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":42,"score":null,"hot":3368777222,"url":"https:\/\/community.smartsheet.com\/discussion\/105374\/form-logic-is-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105374\/form-logic-is-not-working","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DRG2SQ7MP7Y9\/capture1-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture1.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-18T14:30:33+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":105404,"type":"question","name":"#INVALID COLUMN VALUE","excerpt":"I am trying to run some formulas using data including a cell with a date but am receiving an #INVALID COLUMN VALUE error. The cell, which is actually part of a larger data set organized in a column, is linked from another sheet. Both the original cell and the linked cell are formatted as dates. The same error occurs when…","categoryID":321,"dateInserted":"2023-05-18T12:09:45+00:00","dateUpdated":"2023-05-18T12:11:24+00:00","dateLastComment":"2023-05-18T14:25:34+00:00","insertUserID":161575,"insertUser":{"userID":161575,"name":"LGraf","url":"https:\/\/community.smartsheet.com\/profile\/LGraf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-02T08:37:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161575,"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-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":67,"score":null,"hot":3368835919,"url":"https:\/\/community.smartsheet.com\/discussion\/105404\/invalid-column-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105404\/invalid-column-value","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-18T17:15:51+00:00","dateAnswered":"2023-05-18T14:25:34+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":281,"urlcode":"Support","name":"Support"}],"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}">