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,460
- Project Management4,335
- Sheets3,654
- Reports2,546
- 形式2,321
- functionality2,112
- Automations1,758
- IT & Operations1,744
- Support1,521
- Cell linking1,509
- Enhancement Request1,488
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,212
- Conditional Formatting1,184
- Dashboards1,166
- Construction1,085
- API and Developers884
- Sharing and Collaboration875
- Manufacturing862
- 更新请求801
- Workflows in Smartsheet781
- Gantt View775
- Product Development769
- Attachments763
Give this a try:<\/p>
=COUNTIFS([Warranty Phase]:[Warranty Phase], \"Move in Items\", [Status]:[Status], OR(@cell = \"In Progress\", @cell = \"Not Started\"))<\/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":107571,"type":"question","name":"Yellow Code Not Working in Formula","excerpt":"I have the underlying code in a sheet to look at specific items in a row. The Red and Green Code is working as expected by my yellow code is not. I am assuming it has to do with the way I have sestup the today function I have tried both =TODAY(2) and >=TODAY(2) niether seems to work. IF(AND([Due Date]@row = TODAY(2),…","snippet":"I have the underlying code in a sheet to look at specific items in a row. The Red and Green Code is working as expected by my yellow code is not. I am assuming it has to do with…","categoryID":322,"dateInserted":"2023-07-13T17:28:22+00:00","dateUpdated":null,"dateLastComment":"2023-07-13T21:58:08+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162256,"lastUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":27,"score":null,"hot":3378558990,"url":"https:\/\/community.smartsheet.com\/discussion\/107571\/yellow-code-not-working-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107571\/yellow-code-not-working-in-formula","format":"Rich","lastPost":{"discussionID":107571,"commentID":385170,"name":"Re: Yellow Code Not Working in Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385170#Comment_385170","dateInserted":"2023-07-13T21:58:08+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+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-13T21:57:50+00:00","dateAnswered":"2023-07-13T20:00:01+00:00","acceptedAnswers":[{"commentID":385104,"body":"
Try this:<\/p>
=IF(Status@row <> \"Complete\", IF([Due Date]@row< TODAY(), \"Red\", IF([Due Date]@row>= TODAY(3), \"Green\", \"Yellow\"))<\/p>
<\/p>
The main issue with your formula is that you are saying to only flag yellow when the due date is equal to TODAY(2) instead of less than or equal to.<\/p>"},{"commentID":385144,"body":"
There are a number of ways to do this. The most secure way would actually mean a restructure and an OR statement:<\/p>
=IF(Status@row <> \"Complete\", IF(OR([Due Date]@row = \"\", [Due Date]@row.= TODAY(3)), \"Green\", IF([Due Date]@row< TODAY(), \"Red\", \"Yellow\"))<\/p>
<\/p>
I moved the Green argument to be first because sometimes Smartsheet will read a blank cell as being less than a non-blank cell. If we had left it in the original order, this would have meant it would flag as true on the red argument when the due date was blank.<\/p>
<\/p>
Of course there are a number of other ways to do it, but this would be my personally preferred method.<\/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":[]}],"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":[]}">
