讨论
\"Green\")) + \" Project(s) at ACME ROADRUNNER\" Unfortunately it returns a value of \"0\". Should be \"4\". Thanks in advance for any help.","categoryID":322,"dateInserted":"2023-04-01T19:11:19+00:00","dateUpdated":null,"dateLastComment":"2023-04-01T22:28:22+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":37466,"lastUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":45,"score":null,"hot":3360765581,"url":"https:\/\/community.smartsheet.com\/discussion\/103491\/countifs-has-dropdown-with-multiple-selections-possible-in-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103491\/countifs-has-dropdown-with-multiple-selections-possible-in-a-cell","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-03T08:55:47+00:00","dateAnswered":"2023-04-01T22:24:13+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":[],"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":94776,"type":"question","name":"SUM & SUMIFS","excerpt":"I have columns named: Item Description (That contains within a text (Z123) Quantity Received (Check Box) Not sure if you can use SUM and SUMIFS in same formula Looking for a result of ~~ Out of a total of (NUMBER) you have received(NUMBER). Thanks!","categoryID":322,"dateInserted":"2022-08-27T13:05:50+00:00","dateUpdated":null,"dateLastComment":"2022-08-27T15:32:33+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":137768,"lastUser":{"userID":137768,"name":"Brent Wilson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brent%20Wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4QPZ65MHZGWY\/nMW66T7N2KFFS.jpg","dateLastActive":"2023-08-17T17:09:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":82,"score":null,"hot":3323221103,"url":"https:\/\/community.smartsheet.com\/discussion\/94776\/sum-sumifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94776\/sum-sumifs","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-27T15:30: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"}],"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":94317,"type":"idea","name":"Increment Conditions date(s) along with Trigger date","excerpt":"The trigger date increments weekly. The conditions date should also. I enter notes daily throughout the week. The following Monday I want the previous weeks notes sent to X to review the previous week.","categoryID":349,"dateInserted":"2022-08-16T09:58:59+00:00","dateUpdated":null,"dateLastComment":"2022-08-16T14:25:28+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+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-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":214,"score":1,"hot":3321305967,"url":"https:\/\/community.smartsheet.com\/discussion\/94317\/increment-conditions-date-s-along-with-trigger-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94317\/increment-conditions-date-s-along-with-trigger-date","format":"Rich","groupID":null,"statusID":10006,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DDMJU0U6AC19\/smartsheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet.PNG"},"attributes":{"idea":{"statusNotes":null,"statusID":10006,"status":{"name":"Active","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":334,"urlcode":"automations","name":"Automations"},{"tagID":459,"urlcode":"Active","name":"Active"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":94273,"type":"question","name":"Workflow Automation","excerpt":"When I set this up I was hoping that the \"Date is between\" would increment weekly to coincide with the \"When a date is reached\". It does not. Did I miss something or it's not possible? Thanks","categoryID":321,"dateInserted":"2022-08-15T15:21:59+00:00","dateUpdated":null,"dateLastComment":"2022-08-16T10:08:37+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+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-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":95,"score":null,"hot":3321223836,"url":"https:\/\/community.smartsheet.com\/discussion\/94273\/workflow-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94273\/workflow-automation","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QKBJDDSB71OR\/smartsheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-16T10:01:23+00:00","dateAnswered":"2022-08-15T18:40:40+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":90507,"type":"question","name":"Regarding Index\/Match function","excerpt":"I have a work sheet that uses Index\/Match formula. The reference sheet is separate from the worksheet. Question - If I share both sheets with a coworker and they save both on their computer. Will the sheet be able to find the reference sheet without any intervention (i.e. redoing the formula) Thanks","categoryID":322,"dateInserted":"2022-04-26T20:30:20+00:00","dateUpdated":null,"dateLastComment":"2022-04-27T14:15:38+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":37466,"lastUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":98,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/90507\/regarding-index-match-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90507\/regarding-index-match-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-04-27T14:15:50+00:00","dateAnswered":"2022-04-27T14:15:38+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":[],"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":90317,"type":"question","name":"Index Match","excerpt":"My first attempt to use this function. I have a worksheet that has a column (Category). Properties set for dropdown \/ single select. Rather laborious to manually click on every cell and select. Two other columns contain Product description column and part number column. The dropdown column places the item in a category. I…","categoryID":322,"dateInserted":"2022-04-21T01:29:27+00:00","dateUpdated":null,"dateLastComment":"2022-04-21T01:42:04+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":127181,"lastUser":{"userID":127181,"name":"James Keuning","title":"","url":"https:\/\/community.smartsheet.com\/profile\/James%20Keuning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T12:40:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":254,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/90317\/index-match","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/90317\/index-match","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-04-21T01:42:04+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":[],"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":89697,"type":"question","name":"Question regarding a Form, Automated work flow, and Request an Update.","excerpt":"I have a form with an automated work flow. Three of the cells are for names - actually email address. The column properties are set as \"Contact List...\" The last question on the form is \"Request an update\". The default selection is \"Yes\" How I am hoping how this will work is as follows: John Doe enters the three cells with…","categoryID":322,"dateInserted":"2022-04-02T01:29:34+00:00","dateUpdated":null,"dateLastComment":"2022-04-05T10:09:43+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+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-08-22T17:41:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":124,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/89697\/question-regarding-a-form-automated-work-flow-and-request-an-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89697\/question-regarding-a-form-automated-work-flow-and-request-an-update","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-04-05T10:09:43+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":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":88407,"type":"question","name":"Countif and Multi line cell","excerpt":"Column 1: Status Column2: Count Column 1: test Column 2: =COUNTIF([BOP Status]@row, \"test\") Result = 1 Column 1: 2 lines. (1st line \"test\" , then Alt-enter, then \"found in a test\" Column 2: =COUNTIF([BOP Status]@row, \"test\") Result =0 Is there something about using Alt-Enter that causes this issue? is there a work-around?…","categoryID":322,"dateInserted":"2022-02-25T23:50:58+00:00","dateUpdated":null,"dateLastComment":"2022-02-26T09:50:58+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":37466,"lastUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":483,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/88407\/countif-and-multi-line-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88407\/countif-and-multi-line-cell","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-02-26T09:50:14+00:00","dateAnswered":"2022-02-26T05:23:32+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":[],"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":87718,"type":"question","name":"Request an Update Automation - specific rows","excerpt":"I have a form that asks for three names separately. Three different roles. The last question on the form asks, “Request an Update”. Defaults yes The worksheet has three columns to match the name\/role. Column properties set as “contact list” Automation uses “Request an Update” · Trigger: When rows are changed AND when…","categoryID":321,"dateInserted":"2022-02-07T00:55:47+00:00","dateUpdated":null,"dateLastComment":"2022-02-07T07:23:14+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+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-22T19:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":92,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/87718\/request-an-update-automation-specific-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87718\/request-an-update-automation-specific-rows","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-02-07T07:23:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":50261,"type":"discussion","name":"Smartsheet Function - TODAY()","excerpt":"I use this function, TODAY(), to calculate days to an event or past said event. I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate. I use this day counts in a Dashboard and to be accurate, as mentioned, I need to open that particular…","categoryID":322,"dateInserted":"2019-06-11T09:22:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-28T13:54:02+00:00","insertUserID":37466,"insertUser":{"userID":37466,"name":"DanielGD","url":"https:\/\/community.smartsheet.com\/profile\/DanielGD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cpjcJ8xw_dY!5Z_cOfmGcvw!OIxXyVjStX0","dateLastActive":"2023-04-02T12:11:53+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-23T01:18:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":1656,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/50261\/smartsheet-function-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/50261\/smartsheet-function-today","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
