Cell linking

=DATE(2018, 4, 1)) Next I'd like to add…","categoryID":322,"dateInserted":"2018-07-24T17:24:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-09-01T13:15:26+00:00","insertUserID":55506,"insertUser":{"userID":55506,"name":"jjimenez55506","url":"https:\/\/community.smartsheet.com\/profile\/jjimenez55506","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-24T17:09:57+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-09-26T15:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":70,"countViews":8876,"score":null,"hot":3226069183,"url":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/regular_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smiley"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":109730,"type":"question","name":"Is there an automation\/formula that allows a copied row to be updated?","excerpt":"I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…","categoryID":321,"dateInserted":"2023-08-31T18:17:11+00:00","dateUpdated":"2023-08-31T18:24:59+00:00","dateLastComment":"2023-09-01T13:08:05+00:00","insertUserID":165964,"insertUser":{"userID":165964,"name":"lmmayer","title":"Program Specialist","url":"https:\/\/community.smartsheet.com\/profile\/lmmayer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-01T19:04:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":165964,"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-09-26T15:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":85,"score":null,"hot":3387082516,"url":"https:\/\/community.smartsheet.com\/discussion\/109730\/is-there-an-automation-formula-that-allows-a-copied-row-to-be-updated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109730\/is-there-an-automation-formula-that-allows-a-copied-row-to-be-updated","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-09-01T12:08:20+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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":109719,"type":"question","name":"Matching Neighbor Cells or Rows to Most Recent Date","excerpt":"Hey All, Background: Im trying to build a fluid dashboard that tracks information coming in from a form. This form is then routed to several sheets where I break it down further based on certain criteria. I am looking for a way to report on the most recent metrics in the given sheet using the sheet summary feature to make…","categoryID":322,"dateInserted":"2023-08-31T16:14:58+00:00","dateUpdated":null,"dateLastComment":"2023-08-31T16:33:42+00:00","insertUserID":165952,"insertUser":{"userID":165952,"name":"Nick_Frisbee","title":"Agricultural Researcher","url":"https:\/\/community.smartsheet.com\/profile\/Nick_Frisbee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZdyI8dE07M!xdHz8c8f9XM!hcfqu-EEFyw","dateLastActive":"2023-09-11T15:41:46+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-09-26T15:26:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":63,"score":null,"hot":3386999920,"url":"https:\/\/community.smartsheet.com\/discussion\/109719\/matching-neighbor-cells-or-rows-to-most-recent-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109719\/matching-neighbor-cells-or-rows-to-most-recent-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-31T16:26:02+00:00","dateAnswered":"2023-08-31T16:19:33+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":277,"urlcode":"integrations","name":"Integrations"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":109679,"type":"question","name":"How can I create a sheet that counts occurrences of a word in multiple sheets?","excerpt":"I would like to create a sheet that tallies up all the instances of certain words, such as 'retain', 'rotate', 'textile', etc., from multiple sheets. So it would look like: Retain - 30 Rotate - 50 Textile - 20 etc. Is this possible?","categoryID":322,"dateInserted":"2023-08-30T21:05:24+00:00","dateUpdated":null,"dateLastComment":"2023-08-31T08:15:54+00:00","insertUserID":165914,"insertUser":{"userID":165914,"name":"moorejr","url":"https:\/\/community.smartsheet.com\/profile\/moorejr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-30T22:35:32+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-09-26T17:32:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3386901078,"url":"https:\/\/community.smartsheet.com\/discussion\/109679\/how-can-i-create-a-sheet-that-counts-occurrences-of-a-word-in-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109679\/how-can-i-create-a-sheet-that-counts-occurrences-of-a-word-in-multiple-sheets","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-08-30T21:50:42+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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":109167,"type":"idea","name":"Please Remove Cross-Sheet Reference Limit","excerpt":"I am currently trying to pull in data from multiple different sheets into 1 summary view sheet and hit the 100 unique cross-reference max limit, and I am not even halfway finished with my task. Can this limit please be removed or at the very least increased to a much larger number?","categoryID":349,"dateInserted":"2023-08-18T18:40:34+00:00","dateUpdated":null,"dateLastComment":"2023-08-29T20:19:48+00:00","insertUserID":165143,"insertUser":{"userID":165143,"name":"Jessica Limke","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Limke","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtd8xP2QVZaB2Av0MW4IX9nePuVy2vOVta2rdh_umuOKqMA=s96-c","dateLastActive":"2023-09-26T17:42:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162619,"lastUser":{"userID":162619,"name":"RolandoN","title":"Business Intelligence Analyst IV","url":"https:\/\/community.smartsheet.com\/profile\/RolandoN","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xJFWcXWt6_o!ZNlX2XGJbTw!NdMZCY1YlK6","dateLastActive":"2023-09-13T21:09:52+00:00","banned":0,"punished":0,"private":true,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":143,"score":3,"hot":3385727122,"url":"https:\/\/community.smartsheet.com\/discussion\/109167\/please-remove-cross-sheet-reference-limit","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109167\/please-remove-cross-sheet-reference-limit","format":"Rich","groupID":null,"statusID":10000,"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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":535,"urlcode":"cell-reference-limits","name":"Cell Reference Limits"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109600,"type":"idea","name":"Syncing links between Smartsheet and Salesforce","excerpt":"I use the Salesforce Connector to synchronize information between Smartsheet and Salesforce. One of the fields we want to show in Salesforce contains a link to a project dashboard in Smartsheet. The cell with the link normally contains the project name hyperlinked to the dashboard. However, the connector will only copy the…","categoryID":349,"dateInserted":"2023-08-29T17:17:23+00:00","dateUpdated":null,"dateLastComment":"2023-08-29T17:17:23+00:00","insertUserID":143976,"insertUser":{"userID":143976,"name":"mdemul","url":"https:\/\/community.smartsheet.com\/profile\/mdemul","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pVNUaRduq_o!nzVVP0N3AuQ!J7x_RaexxKM","dateLastActive":"2023-09-22T17:27:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":143976,"lastUser":{"userID":143976,"name":"mdemul","url":"https:\/\/community.smartsheet.com\/profile\/mdemul","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pVNUaRduq_o!nzVVP0N3AuQ!J7x_RaexxKM","dateLastActive":"2023-09-22T17:27:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":70,"score":1,"hot":1693329743,"url":"https:\/\/community.smartsheet.com\/discussion\/109600\/syncing-links-between-smartsheet-and-salesforce","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109600\/syncing-links-between-smartsheet-and-salesforce","format":"Rich","groupID":null,"statusID":10000,"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":277,"urlcode":"integrations","name":"Integrations"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109575,"type":"question","name":"#IF INDEX\/MATCH Returning #INVALID OPERATION","excerpt":"I am fairly new to formulas in Smartsheet, and I am having trouble with the following formula where I am trying to check a Checkbox from another sheet (\"Devices Secured\") and set a Text\/Number value (\"Device Security OK\") to either \"OK\" or \"Not OK\" based on whether the Checkbox is checked or not. This seems fairly…","categoryID":322,"dateInserted":"2023-08-29T13:45:17+00:00","dateUpdated":null,"dateLastComment":"2023-08-29T13:59:32+00:00","insertUserID":161978,"insertUser":{"userID":161978,"name":"KevinBradford","title":"Information Security Analyst","url":"https:\/\/community.smartsheet.com\/profile\/KevinBradford","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf8LXZX7IqoSAtxN72Jr-m5K_uIU3hoGF9KuMt5mIK1uzM=s96-c","dateLastActive":"2023-09-22T11:58:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161978,"lastUser":{"userID":161978,"name":"KevinBradford","title":"Information Security Analyst","url":"https:\/\/community.smartsheet.com\/profile\/KevinBradford","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf8LXZX7IqoSAtxN72Jr-m5K_uIU3hoGF9KuMt5mIK1uzM=s96-c","dateLastActive":"2023-09-22T11:58:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":3386635489,"url":"https:\/\/community.smartsheet.com\/discussion\/109575\/if-index-match-returning-invalid-operation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109575\/if-index-match-returning-invalid-operation","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5U2VYF4BVTWS\/formula-sheet.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula Sheet.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-29T14:11:50+00:00","dateAnswered":"2023-08-29T13:54:03+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":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}">