Formulas and Functions

=TODAY(-30)\")","categoryID":322,"dateInserted":"2020-05-21T23:11:10+00:00","dateUpdated":"2020-05-21T23:11:55+00:00","dateLastComment":"2020-05-26T13:34:17+00:00","insertUserID":105561,"insertUser":{"userID":105561,"name":"nmazardw","url":"https:\/\/community.smartsheet.com\/profile\/nmazardw","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-26T13:27:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":105561,"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":10,"countViews":1649,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/68550\/count-if-greater-than-or-equal-to-30-days-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68550\/count-if-greater-than-or-equal-to-30-days-from-today","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-27T09:42:22+00:00","dateAnswered":"2020-05-26T13:17:21+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":68549,"type":"question","name":"Count Formula","excerpt":"Hello! I am tracking assignments and a person can have more than one assignment. I need to be able to count the number of persons assigned on the sheet but don't want to count dupes. The fields are \"First Name\" and \"Last Name\". I'm trying to use the =COUNT(DISTINCT(RANGE) formula but I'm not having any success. Also, there…","categoryID":322,"dateInserted":"2020-05-21T22:56:46+00:00","dateUpdated":"2020-05-21T23:14:06+00:00","dateLastComment":"2020-05-26T13:33:59+00:00","insertUserID":72151,"insertUser":{"userID":72151,"name":"jgneely72151","url":"https:\/\/community.smartsheet.com\/profile\/jgneely72151","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uklX13GVkLw!3ltWfxWoEjo!iKtqRtLLlOS","dateLastActive":"2023-07-11T17:12:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":72151,"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":14,"countViews":135,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/68549\/count-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68549\/count-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-22T13:40:38+00:00","dateAnswered":"2020-05-22T12:22:46+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":319,"urlcode":"functionality","name":"functionality"}],"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":68571,"type":"question","name":"Summary Report Formula","excerpt":"What is the formula for this scenario: I have laborers working at different job addresses, I want to calculate the total cost by Laborer Name and by each Job Address in a summary report. Below is the data. The result I am looking for would look something like this in a summary report for my bookkeeper to easily write…","categoryID":322,"dateInserted":"2020-05-22T19:48:04+00:00","dateUpdated":null,"dateLastComment":"2020-05-26T13:27:35+00:00","insertUserID":121423,"insertUser":{"userID":121423,"name":"Lisa_Doris","url":"https:\/\/community.smartsheet.com\/profile\/Lisa_Doris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpvCNzlAPD4!zhDAc0lb11Y!4w3IvUsBivD","dateLastActive":"2021-10-02T00:47:20+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":6,"countViews":73,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/68571\/summary-report-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68571\/summary-report-formula","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":68570,"type":"question","name":"Using colum % complete","excerpt":"Hi, I would like to know how I can assign the porcentage in the % complete column. If my stage has a duration of 20 days and I want to assign for each day%.","categoryID":322,"dateInserted":"2020-05-22T19:13:42+00:00","dateUpdated":null,"dateLastComment":"2020-05-26T12:28:00+00:00","insertUserID":121510,"insertUser":{"userID":121510,"name":"JOSE IBANEZ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JOSE%20IBANEZ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-26T21:34:30+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":6,"countViews":78,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/68570\/using-colum-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68570\/using-colum-complete","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":68598,"type":"question","name":"Countif Function where criterion is content of a cell","excerpt":"Hi All, I need some help with a countifs functions I want the formula to provide me with the count of the cells that contain a specific text. Is there a way to point directly to the cell that contains that text rather than spell it out ? For example =COUNTIF([Column A]:[Column A], \"Text\") This works fine, but I would want…","categoryID":322,"dateInserted":"2020-05-26T08:40:11+00:00","dateUpdated":null,"dateLastComment":"2020-05-26T11:38:02+00:00","insertUserID":121783,"insertUser":{"userID":121783,"name":"Stefano Ferretti","url":"https:\/\/community.smartsheet.com\/profile\/Stefano%20Ferretti","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!b-DWm299PmY!n1DUn09JAVY!zAuSjVP5PCI","dateLastActive":"2023-03-30T15:10:20+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":4,"countViews":211,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/68598\/countif-function-where-criterion-is-content-of-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68598\/countif-function-where-criterion-is-content-of-a-cell","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":68583,"type":"question","name":"Why does my chart widget display a different numeric percentage scale on different phones?","excerpt":"We use dashboards extensively with remote teams. Most people have no problem accessing and seeing information correctly on the mobile app. I have one person, the President, that see the numeric percentage scale differently on his phone. No problem on his desktop and I'm not aware of anyone else having this issue. I have…","categoryID":322,"dateInserted":"2020-05-23T19:03:33+00:00","dateUpdated":null,"dateLastComment":"2020-05-26T07:48:17+00:00","insertUserID":99941,"insertUser":{"userID":99941,"name":"smitzel99941","url":"https:\/\/community.smartsheet.com\/profile\/smitzel99941","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pEPDqbk3oL4!AjHCB1lBOP4!5RMtNbfbK-V","dateLastActive":"2020-05-26T22:22: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-08-26T17:06:33+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\/68583\/why-does-my-chart-widget-display-a-different-numeric-percentage-scale-on-different-phones","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68583\/why-does-my-chart-widget-display-a-different-numeric-percentage-scale-on-different-phones","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/V5F8FYLKYOE7\/image1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image1.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}]},{"discussionID":68590,"type":"question","name":"Verifying Created by Column with Manager Email Column","excerpt":"I'm trying to show verification for a contact email address to match the \"Created by\" field generated by Smartsheet to ensure an entry\/request is valid\/accurate. Can someone help me out with this? Essentially flagging people with inconsistent data. Thanks so much.","categoryID":322,"dateInserted":"2020-05-24T21:42:10+00:00","dateUpdated":null,"dateLastComment":"2020-05-25T23:51:13+00:00","insertUserID":121902,"insertUser":{"userID":121902,"name":"Don Williams","url":"https:\/\/community.smartsheet.com\/profile\/Don%20Williams","photoUrl":"https:\/\/lh3.googleusercontent.com\/-u_i4MwJBqqE\/AAAAAAAAAAI\/AAAAAAAAArA\/vY1f8yQpMcM\/photo.jpg","dateLastActive":"2020-06-17T21:59:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121902,"lastUser":{"userID":121902,"name":"Don Williams","url":"https:\/\/community.smartsheet.com\/profile\/Don%20Williams","photoUrl":"https:\/\/lh3.googleusercontent.com\/-u_i4MwJBqqE\/AAAAAAAAAAI\/AAAAAAAAArA\/vY1f8yQpMcM\/photo.jpg","dateLastActive":"2020-06-17T21:59:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":72,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/68590\/verifying-created-by-column-with-manager-email-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68590\/verifying-created-by-column-with-manager-email-column","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-25T23:51:16+00:00","dateAnswered":"2020-05-25T01:10: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":[],"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":68392,"type":"question","name":"Approval Flow Notification Bug or am I doing something wrong?","excerpt":"Good morning everyone. I have a sheet linked to a request form which based on the info submitted needs to be approved by a number of people. I have 14 approval workflows, based on country of the requestor, the total amount requested, and or reason for request. There are 4 to 5 approvals required based on the type of…","categoryID":322,"dateInserted":"2020-05-18T09:00:39+00:00","dateUpdated":"2020-05-18T09:03:33+00:00","dateLastComment":"2020-05-25T14:51:55+00:00","insertUserID":116326,"insertUser":{"userID":116326,"name":"JDen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JDen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xb9aMUWTN_o!ATNZQJGOEDw!q0-xnTxsSEU","dateLastActive":"2022-06-22T14:57:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":116326,"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":7,"countViews":424,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/68392\/approval-flow-notification-bug-or-am-i-doing-something-wrong","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68392\/approval-flow-notification-bug-or-am-i-doing-something-wrong","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-25T14:34:30+00:00","dateAnswered":"2020-05-25T09:20:47+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