Formulas and Functions

= TODAY(60)) Where's the error? Thank you!","categoryID":322,"dateInserted":"2020-10-14T17:43:33+00:00","dateUpdated":null,"dateLastComment":"2020-10-20T19:45:49+00:00","insertUserID":66561,"insertUser":{"userID":66561,"name":"Debbie Petersen","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Petersen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-11T15:21:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":66561,"lastUser":{"userID":66561,"name":"Debbie Petersen","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Petersen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-11T15:21:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":20,"countViews":252,"score":null,"hot":20,"url":"https:\/\/community.smartsheet.com\/discussion\/72222\/trying-to-count-number-of-items-with-a-date-in-the-next-60-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72222\/trying-to-count-number-of-items-with-a-date-in-the-next-60-days","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-12-06T15:29:55+00:00","dateAnswered":"2020-10-15T15:43:00+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":72398,"type":"question","name":"Number of Month Payback ROI","excerpt":"Hi everyone, I have created a form and the pictures below is what is relevant to my question. We have projects with a fiscal year start date and end date, we also want to know the payback date. I did not chose the \"date\" function on the column as we are only interested in the fiscal year, but maybe there is a work around.…","categoryID":322,"dateInserted":"2020-10-20T14:51:19+00:00","dateUpdated":null,"dateLastComment":"2020-10-20T18:38:19+00:00","insertUserID":125387,"insertUser":{"userID":125387,"name":"Lila De Vera","url":"https:\/\/community.smartsheet.com\/profile\/Lila%20De%20Vera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BqDeQW6uPGY!wx9f_6KbvvQ!zYdjWnf2PiH","dateLastActive":"2021-10-29T17:42:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":136,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72398\/number-of-month-payback-roi","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72398\/number-of-month-payback-roi","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BA8L2TGJX5IY\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-20T16:38:31+00:00","dateAnswered":"2020-10-20T15:46:50+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":72378,"type":"question","name":"INDEX MATCH range across a row?","excerpt":"Wise People in my Computer, Can I set the range for an INDEX MATCH formula across multiple columns in one row, instead of a column? My testing is suggesting the answer is no...am I missing something, else what might I use instead? I am trying to return the name of a Reviewer into my Lead Reviewer column, pulling from the…","categoryID":322,"dateInserted":"2020-10-19T22:12:27+00:00","dateUpdated":null,"dateLastComment":"2020-10-20T18:36:41+00:00","insertUserID":32236,"insertUser":{"userID":32236,"name":"Hannah H","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZeFcGeWAcfo!Gf1cngBnqcQ!VWV6sr8ONJO","dateLastActive":"2021-06-18T18:06:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":115578,"lastUser":{"userID":115578,"name":"David Joyeuse","url":"https:\/\/community.smartsheet.com\/profile\/David%20Joyeuse","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2021-08-19T14:05:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":389,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72378\/index-match-range-across-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72378\/index-match-range-across-a-row","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8W3SQPAYSD6D\/screen-shot-2020-10-19-at-3-02-26-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-10-19 at 3.02.26 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-10-20T16:11:25+00:00","dateAnswered":"2020-10-20T15:51:30+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":72337,"type":"question","name":"Question on SumIFS","excerpt":"We're hosting a \"Bike to the Moon\" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field that sums across all their trips (rows.) I'm using this formula at the moment but I'd rather not…","categoryID":322,"dateInserted":"2020-10-17T23:54:26+00:00","dateUpdated":null,"dateLastComment":"2020-10-20T18:03:57+00:00","insertUserID":127700,"insertUser":{"userID":127700,"name":"Vanessa Sandom","url":"https:\/\/community.smartsheet.com\/profile\/Vanessa%20Sandom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-08-02T18:57:07+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-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/72337\/question-on-sumifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72337\/question-on-sumifs","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-23T21:29:41+00:00","dateAnswered":"2020-10-20T18:03:57+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":265,"urlcode":"Reports","name":"Reports"},{"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}]},{"discussionID":72411,"type":"question","name":"Can selections from a list be added to each row under a job based on job criteria?","excerpt":"I am not thinking this is a possibility, but thought I'd ask in case I missed something. Can a list of tasks be populated in the rows under a new job row based on criteria in a different row? For instance, I have a column for project type and a column for project tasks. If Sign is selected as the project type, can…","categoryID":322,"dateInserted":"2020-10-20T17:26:12+00:00","dateUpdated":null,"dateLastComment":"2020-10-20T17:58:08+00:00","insertUserID":125119,"insertUser":{"userID":125119,"name":"Leslie Merlino","url":"https:\/\/community.smartsheet.com\/profile\/Leslie%20Merlino","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2uFCv6ES2fo!!goneEoIJmGH","dateLastActive":"2022-08-30T19:27:16+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-07-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/72411\/can-selections-from-a-list-be-added-to-each-row-under-a-job-based-on-job-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72411\/can-selections-from-a-list-be-added-to-each-row-under-a-job-based-on-job-criteria","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-12T19:32:36+00:00","dateAnswered":"2020-10-20T17:58:08+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources