Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Sign in andask it here!The community's got your back.
Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.
Check what Support you have access to based on your Plan
Overview of Smartsheet support hours and resources
Share your knowledge!
Help others byanswering questions.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas10,430
- Project Management4,332
- Sheets3651年
- Reports2,543
- Forms2,317
- functionality2,108
- Automations1,747
- IT & Operations1,743
- Support1,519
- Cell linking1,507
- Enhancement Request1,485
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,211
- Conditional Formatting1,183
- Dashboards1,164
- Construction1,084
- API and Developers884
- Sharing and Collaboration874
- Manufacturing862
- Update Requests798
- Gantt View775
- Workflows in Smartsheet772
- Product Development768
- Attachments762
Check out theFormula Handbook template!
If you're just wanting the month to compare to last (e.g. July today vs. June last), then this will do what you're after:<\/p>
=IF(AND(YEAR(Created@row) = YEAR(TODAY()), MONTH(Created@row) = (MONTH(TODAY())) - 1), 1)<\/p>
Hope this helps! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107331,"type":"question","name":"COUNTIF For multiple Drop down values in Same Column","excerpt":"Hi. Hoping someone can guide me. I have a formula in Calc sheet pulling from an Action Log template used in Control Centre, that originally only picked up one value and had an IFERROR Statement included and a minus figure to ignore what was in a placeholder row at the top. That formula was =(IFERROR(COUNTIF({Action Log…","snippet":"Hi. Hoping someone can guide me. I have a formula in Calc sheet pulling from an Action Log template used in Control Centre, that originally only picked up one value and had an…","categoryID":322,"dateInserted":"2023-07-07T11:17:45+00:00","dateUpdated":"2023-07-07T11:46:21+00:00","dateLastComment":"2023-07-07T14:06:22+00:00","insertUserID":128162,"insertUser":{"userID":128162,"name":"Tim Wing","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Wing","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T14:06:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":128162,"lastUser":{"userID":128162,"name":"Tim Wing","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Wing","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T14:06:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3377468647,"url":"https:\/\/community.smartsheet.com\/discussion\/107331\/countif-for-multiple-drop-down-values-in-same-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107331\/countif-for-multiple-drop-down-values-in-same-column","format":"Rich","lastPost":{"discussionID":107331,"commentID":384170,"name":"Re: COUNTIF For multiple Drop down values in Same Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384170#Comment_384170","dateInserted":"2023-07-07T14:06:22+00:00","insertUserID":128162,"insertUser":{"userID":128162,"name":"Tim Wing","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20Wing","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T14:06:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T14:06:00+00:00","dateAnswered":"2023-07-07T11:50:30+00:00","acceptedAnswers":[{"commentID":384130,"body":"
=(IFERROR(COUNTIF({5) Action Log Range 1}, or(@cell = \"In Progress\",@cell = \"Not Started\"), 0)) - 1<\/p>
<\/p>
Your range name is a little wonky, I don't know if you made a typo or not, but if it's correct then this should work.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":107325,"type":"question","name":"Incorrect Argument Set","excerpt":"Hi All, I have a formula that worked in one row, but then when I make it a column formula, it shows \"incorrect argument set\" in all the other rows but the 1st one. Please see below: That's the formula: =IF(AND([CLIENT TYPE]@row = \"Platinum\", [TOTAL AGING]@row > 1), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED…","snippet":"Hi All, I have a formula that worked in one row, but then when I make it a column formula, it shows \"incorrect argument set\" in all the other rows but the 1st one. Please see…","categoryID":322,"dateInserted":"2023-07-07T08:10:18+00:00","dateUpdated":null,"dateLastComment":"2023-07-07T10:46:00+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T14:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":158375,"lastUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T14:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":38,"score":null,"hot":3377445378,"url":"https:\/\/community.smartsheet.com\/discussion\/107325\/incorrect-argument-set","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107325\/incorrect-argument-set","format":"Rich","lastPost":{"discussionID":107325,"commentID":384125,"name":"Re: Incorrect Argument Set","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384125#Comment_384125","dateInserted":"2023-07-07T10:46:00+00:00","insertUserID":158375,"insertUser":{"userID":158375,"name":"angelapaj","url":"https:\/\/community.smartsheet.com\/profile\/angelapaj","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4smdwuoBbo!BYfnwW-eMzI!G-HqZABFep4","dateLastActive":"2023-07-07T14:03:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VE1CT9T9NVPK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-07T10:44:50+00:00","dateAnswered":"2023-07-07T10:02:51+00:00","acceptedAnswers":[{"commentID":384119,"body":"
Can you try the formula below?<\/p>
=IF(AND([CLIENT TYPE]@row = \"Platinum\", [TOTAL AGING]@row > 1), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Red\", IF(AND([CLIENT TYPE]@row = \"Gold\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Not Started\"), \"Yellow\", IF(AND([CLIENT TYPE]@row = \"Silver\", [REQUIRED DATE]@row < TODAY(), [DRAWING STATUS]@row = \"Review\"), \"Yellow\", \"Green\")))))\n<\/pre>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
