Formulas and Functions

, <= This is the formula I entered: =IF(TODAY(30) >= [Date…","categoryID":322,"dateInserted":"2020-09-02T16:33:07+00:00","dateUpdated":null,"dateLastComment":"2020-09-06T05:28:31+00:00","insertUserID":125710,"insertUser":{"userID":125710,"name":"Alycia Washington","url":"https:\/\/community.smartsheet.com\/profile\/Alycia%20Washington","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-08T19:04:35+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-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":1043,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/71028\/i-am-trying-to-create-a-formula-that-determines-when-date-is-within-30-60-90-days-from-todays-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71028\/i-am-trying-to-create-a-formula-that-determines-when-date-is-within-30-60-90-days-from-todays-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-03T18:10:03+00:00","dateAnswered":"2020-09-03T17:49:24+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":71111,"type":"question","name":"Move Rows to a sheet - Formulas on the Destination Sheet","excerpt":"I have a sheet where a row starts with about 5 columns. When saved those added rows will be moved to a sheet with a good deal more columns. On that destination sheet (Dest. Sheet 1), I have formulas on several columns (not the same columns that are on the first sheet that are getting moved). When I move rows from the first…","categoryID":322,"dateInserted":"2020-09-04T20:15:40+00:00","dateUpdated":null,"dateLastComment":"2020-09-05T10:07:25+00:00","insertUserID":122778,"insertUser":{"userID":122778,"name":"Kevin Smith","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-09T16:09:40+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-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":93,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71111\/move-rows-to-a-sheet-formulas-on-the-destination-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71111\/move-rows-to-a-sheet-formulas-on-the-destination-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":71105,"type":"question","name":"Is there a way to use a formula to tell my contact cell to populate based on another field?","excerpt":"So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the \"team\" field, then add this matching contact to the \"Assigned to\" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation","categoryID":322,"dateInserted":"2020-09-04T16:30:59+00:00","dateUpdated":null,"dateLastComment":"2020-09-04T20:16:08+00:00","insertUserID":122151,"insertUser":{"userID":122151,"name":"Melissa Logan","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Logan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QP6W2WBQVK6M\/nNZHM19Y4Z9IA.jpg","dateLastActive":"2021-12-28T22:16:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":122151,"lastUser":{"userID":122151,"name":"Melissa Logan","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Logan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QP6W2WBQVK6M\/nNZHM19Y4Z9IA.jpg","dateLastActive":"2021-12-28T22:16:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":56,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71105\/is-there-a-way-to-use-a-formula-to-tell-my-contact-cell-to-populate-based-on-another-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71105\/is-there-a-way-to-use-a-formula-to-tell-my-contact-cell-to-populate-based-on-another-field","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GQNDBJ774Y82\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-04T20:16:32+00:00","dateAnswered":"2020-09-04T17:29:24+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":247,"urlcode":"contacts","name":"Contacts"},{"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}]},{"discussionID":71097,"type":"question","name":"How to autopopulate phone numbers?","excerpt":"I would like to format all input numbers to have the same format (xxx) xxx-xxxx","categoryID":322,"dateInserted":"2020-09-04T14:43:59+00:00","dateUpdated":null,"dateLastComment":"2020-09-04T18:05:35+00:00","insertUserID":125780,"insertUser":{"userID":125780,"name":"Kayla Gaynor","url":"https:\/\/community.smartsheet.com\/profile\/Kayla%20Gaynor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-04T20:14:32+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":174,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71097\/how-to-autopopulate-phone-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71097\/how-to-autopopulate-phone-numbers","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":71103,"type":"question","name":"SUMIF Criteria met","excerpt":"I'm trying to calculate the sum of the numbers in a cell when the cell meets a criteria range. This formula works fine for providing the number in cell that is greater than 30. But what if I want the sum to be the total of the numbers in the cells that are equal to or greater than 25 and less than 30?…","categoryID":322,"dateInserted":"2020-09-04T16:03:38+00:00","dateUpdated":null,"dateLastComment":"2020-09-04T17:30:55+00:00","insertUserID":125786,"insertUser":{"userID":125786,"name":"Ron Erdeljac","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Erdeljac","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jEDVI88owRY!ZxNXWeM1YfQ!IyIONlyO-Fn","dateLastActive":"2021-07-28T19:58:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":121748,"lastUser":{"userID":121748,"name":"John Jonassen","url":"https:\/\/community.smartsheet.com\/profile\/John%20Jonassen","photoUrl":"https:\/\/lh4.googleusercontent.com\/-HbmjQRv-LuA\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuuck6Pa_uek-ruwL0UKJCEr3XppYqFw\/photo.jpg","dateLastActive":"2022-10-05T18:31:41+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\/71103\/sumif-criteria-met","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71103\/sumif-criteria-met","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-04T17:23:13+00:00","dateAnswered":"2020-09-04T17:20:11+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":70869,"type":"question","name":"Formulas not carrying down to new rows","excerpt":"I have a sheet with formulas in most of the columns that should be carrying down to newly added rows but after several months of it working correctly, they no longer carry down. I have checked for blank rows and made sure the formulas are correct in each column and present in every row but after working for awhile, they…","categoryID":322,"dateInserted":"2020-08-26T13:09:30+00:00","dateUpdated":null,"dateLastComment":"2020-09-04T16:49:06+00:00","insertUserID":95571,"insertUser":{"userID":95571,"name":"hmcnamara95571","url":"https:\/\/community.smartsheet.com\/profile\/hmcnamara95571","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTteeZ6uZFBIUtMR4Vyj7W3HjRC9KhutGPUNC4bn8=s96-c","dateLastActive":"2023-07-03T19:45:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":95571,"lastUser":{"userID":95571,"name":"hmcnamara95571","url":"https:\/\/community.smartsheet.com\/profile\/hmcnamara95571","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTteeZ6uZFBIUtMR4Vyj7W3HjRC9KhutGPUNC4bn8=s96-c","dateLastActive":"2023-07-03T19:45:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":134,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/70869\/formulas-not-carrying-down-to-new-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70869\/formulas-not-carrying-down-to-new-rows","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-26T13:18:57+00:00","dateAnswered":"2020-08-26T13:18:17+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":71096,"type":"question","name":"Why are alerts not sending?","excerpt":"I have an alert setup that does not required any approvals. Past the \"send to specific people\" is a whole list of folks, but did not want to show their email addresses. We did a test row yesterday that met all of our conditions below and no alert came through this morning. We've been having a lot of trouble with alerts. No…","categoryID":322,"dateInserted":"2020-09-04T14:43:15+00:00","dateUpdated":null,"dateLastComment":"2020-09-04T15:40:54+00:00","insertUserID":124379,"insertUser":{"userID":124379,"name":"Mandy Maleta","url":"https:\/\/community.smartsheet.com\/profile\/Mandy%20Maleta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZmjemQqQdbQ!!cJhrHdhC3Ku","dateLastActive":"2020-09-04T14:40:44+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71096\/why-are-alerts-not-sending","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71096\/why-are-alerts-not-sending","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/P3KFSMG2ZLF7\/screen-shot-2020-09-04-at-9-40-20-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-09-04 at 9.40.20 AM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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