Formulas and Functions

(MONTH(TODAY())),…","categoryID":322,"dateInserted":"2020-05-18T10:04:50+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T14:35:01+00:00","insertUserID":121671,"insertUser":{"userID":121671,"name":"Suki Teh","url":"https:\/\/community.smartsheet.com\/profile\/Suki%20Teh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-16T08:18:45+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-07-12T21:24:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":72,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68393\/multiple-if-in-the-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68393\/multiple-if-in-the-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":68388,"type":"question","name":"Month to date formula","excerpt":"Hi, Can anyone please suggest with a \"month to date\" formula that I can use in my sheet that is set up as shown in the attachment? I have a column that lists down all the dates in the year 2020. I would like to insert the formula in the checkbox column such that if the criteria is month to date criteria is met, the box…","categoryID":322,"dateInserted":"2020-05-17T21:58:55+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T13:23:50+00:00","insertUserID":92656,"insertUser":{"userID":92656,"name":"sahilhq","url":"https:\/\/community.smartsheet.com\/profile\/sahilhq","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ktnbH9nYd7w!xadbccW79Do!rlAROyRZQOa","dateLastActive":"2020-09-22T15:15:06+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":375,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/68388\/month-to-date-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68388\/month-to-date-formula","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/095\/O5BBPCW1M7WO.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"month to date sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-18T13:16:37+00:00","dateAnswered":"2020-05-18T10:51:25+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":68384,"type":"question","name":"We have a worksheet with a number of dates. I would like a formula to automatically calculate a date","excerpt":"We have a worksheet with a number of dates. I would like a formula to automatically calculate a date 6 weeks before a date in anothor cell? Ie. If \"FYE Date\" is 28.02 or 29.02 then \"start date\" = \"FYE Date\" - 6 weeks. Is this possible?","categoryID":322,"dateInserted":"2020-05-17T14:17:55+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T07:55:07+00:00","insertUserID":121663,"insertUser":{"userID":121663,"name":"Andre de Oliveira","url":"https:\/\/community.smartsheet.com\/profile\/Andre%20de%20Oliveira","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-06T05:40:46+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":82,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68384\/we-have-a-worksheet-with-a-number-of-dates-i-would-like-a-formula-to-automatically-calculate-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68384\/we-have-a-worksheet-with-a-number-of-dates-i-would-like-a-formula-to-automatically-calculate-a-date","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-18T18:43:27+00:00","dateAnswered":"2020-05-18T07:55:07+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":68360,"type":"question","name":"Signature Workflows","excerpt":"Hello, I know that Smartsheet does not have an integrated signature collection feature. However, what signature platforms does it work with? More specifically, does Smartsheet collaborate with Collect Signatures Workflow through SharePoint? Or any other Office 365 signature functions?","categoryID":322,"dateInserted":"2020-05-15T17:55:36+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T07:22:36+00:00","insertUserID":117528,"insertUser":{"userID":117528,"name":"Sidonia Posteuca","url":"https:\/\/community.smartsheet.com\/profile\/Sidonia%20Posteuca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-03T21:04:03+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":103,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68360\/signature-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68360\/signature-workflows","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":68305,"type":"question","name":"COUNTIFS function","excerpt":"Hi All, I have problem with Countifs in Smartsheet during it's still workable in Excell as well. As below picture, I'd like to count product type is \"Goalies Mask\" with result \"FAIL\". I applied formula : =COUNTIFS([Product type]:[Product type],\"Goalie Mask\",[Result]1:[Result],\"FAIL\")) but it shows #UNPARSEABLE. Would you…","categoryID":322,"dateInserted":"2020-05-14T05:07:53+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T07:22:24+00:00","insertUserID":121577,"insertUser":{"userID":121577,"name":"Tony Nguyen","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Nguyen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-12T02:26:56+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-12T20:38:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":61,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/68305\/countifs-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68305\/countifs-function","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/334\/96GH6PPEQFKH.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-14T10:23:59+00:00","dateAnswered":"2020-05-14T06:46: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":68374,"type":"question","name":"Qualifying a contest entry - comparing items between two sheets","excerpt":"Hi I am new to Smartsheet and really wished I could just run a pivot table against a sales contest my team is running. But we are constantly getting new entries through a smartsheet form and I have created a smartsheet dashboard that updates in realtime as the entries come in. I have two sheets: One is the source form…","categoryID":322,"dateInserted":"2020-05-16T00:07:46+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T06:10:41+00:00","insertUserID":121620,"insertUser":{"userID":121620,"name":"Annie Murphy","url":"https:\/\/community.smartsheet.com\/profile\/Annie%20Murphy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-18T20:51:52+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68374\/qualifying-a-contest-entry-comparing-items-between-two-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68374\/qualifying-a-contest-entry-comparing-items-between-two-sheets","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":68373,"type":"question","name":"Need help creating a yes or no smartsheet with result as a percent of amount of yes and no","excerpt":"Need help creating a yes or no smartsheet with result as a percent of amount of yes and no","categoryID":322,"dateInserted":"2020-05-15T23:28:44+00:00","dateUpdated":null,"dateLastComment":"2020-05-18T05:53:47+00:00","insertUserID":121649,"insertUser":{"userID":121649,"name":"Arturo Zepeda","url":"https:\/\/community.smartsheet.com\/profile\/Arturo%20Zepeda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-15T23:38:03+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":509,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68373\/need-help-creating-a-yes-or-no-smartsheet-with-result-as-a-percent-of-amount-of-yes-and-no","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68373\/need-help-creating-a-yes-or-no-smartsheet-with-result-as-a-percent-of-amount-of-yes-and-no","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":68358,"type":"question","name":"Smartsheet live calculating tool (dashboard or form)","excerpt":"For work, when we hire people there are variable and fixed benefit rates based on the type of employee they are. I would like to develop a tool much like a smart form where the user inputs hours per week, wage rate, start and end date and type of employee, and the form displays the total cost of hiring that person. I have…","categoryID":322,"dateInserted":"2020-05-15T17:35:02+00:00","dateUpdated":null,"dateLastComment":"2020-05-17T14:09:49+00:00","insertUserID":121637,"insertUser":{"userID":121637,"name":"Jeremy Clark","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Clark","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14Ghz8n_yyEbsf_l6ZxMmwfUgmEUXLSjoJhMODvjYiQ","dateLastActive":"2020-05-18T19:08:10+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-07-12T21:05:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":242,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68358\/smartsheet-live-calculating-tool-dashboard-or-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68358\/smartsheet-live-calculating-tool-dashboard-or-form","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources