公式

12. In excel it just adds 14 months…","categoryID":317,"dateInserted":"2015-08-25T16:26:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-25T17:17:39+00:00","insertUserID":2901,"insertUser":{"userID":2901,"name":"Chris Parra","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Parra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-08-20T21:25:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2858,"lastUser":{"userID":2858,"name":"Brett Evans","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Evans","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-01T19:43:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":1579,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/2077\/date-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/2077\/date-formula-help","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}],"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":1955,"type":"discussion","name":"Append Text before Formula","excerpt":"I have a formula like below: =ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) \/ 7) + 0.49, 0) How do I append \"ETA Week Number\" before the result of the formula. I have tried the below, but it comes up as UNPARSABLE =“ETA Week Number “ + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) \/ 7) + 0.49, 0)","categoryID":317,"dateInserted":"2015-08-24T03:09:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-24T16:42:01+00:00","insertUserID":3090,"insertUser":{"userID":3090,"name":"J Tech","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J%20Tech","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nPYG63XB2DF2E.png","dateLastActive":"2023-04-28T08:13:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":92,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/1955\/append-text-before-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1955\/append-text-before-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"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":1937,"type":"discussion","name":"Reference a row by Task Name instead of by the row Number.","excerpt":"Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number. The formula is pretty simple. I have a Completion Date column and a…","categoryID":317,"dateInserted":"2015-08-20T15:03:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-08-24T14:33:12+00:00","insertUserID":3150,"insertUser":{"userID":3150,"name":"Megan Heinz","url":"https:\/\/community.smartsheet.com\/profile\/Megan%20Heinz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-01T20:39:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":3150,"lastUser":{"userID":3150,"name":"Megan Heinz","url":"https:\/\/community.smartsheet.com\/profile\/Megan%20Heinz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-01T20:39:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":264,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/1937\/reference-a-row-by-task-name-instead-of-by-the-row-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1937\/reference-a-row-by-task-name-instead-of-by-the-row-number","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}">