Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas9,161
- Project Management4,109
- Sheets3,373
- Reports2,346
- 形式2,079
- functionality1,966
- IT & Operations1,693
- Support1,424
- Cell linking1,384
- Enhancement Request1,374
- Automations1,362
- Email Notifications1,358
- Account and User Management1,353
- Integrations1,158
- Construction1,064
- Technology1,043
- Conditional Formatting1,034
- Dashboards931
- Manufacturing852
- Sharing and Collaboration810
- API and Developers746
- Calendar View716
- Product Development710
- Gantt View708
- Update Requests696
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=IF([ShipC Updated]@row = 1, 1)<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Have a fantastic week & Happy Holidays!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":355142,"body":" @ReneeW<\/a> <\/p> Excellent!<\/p> You're more than welcome!<\/p> You were off with the space at the beginning and the parenthesis at the end.<\/p> =IF_<\/strong>([ShipC Updated]@row = 1)<\/strong>, 1<\/p> ✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-21 19:45:29","updateUser":{"userID":156200,"name":"ReneeW","url":"https:\/\/community.smartsheet.com\/profile\/ReneeW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T20:54:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98993,"type":"question","name":"COUNTIFS Formula","excerpt":"Good morning, I am trying to do a COUNTIFS formula and getting a #Unparseable error here is the formula I am trying to set up. =COUNTIFS([Date]:[Date],(IFERROR(YEAR(@cell), 0) = 2022, IFERROR(MONTH(@cell), 0) = 12),([Exception Category]:[Exception Category], \"TILA\/RESPA\")) Thanks for your help.","categoryID":322,"dateInserted":"2022-12-21T18:01:00+00:00","dateUpdated":null,"dateLastComment":"2022-12-21T19:19:33+00:00","insertUserID":130906,"insertUser":{"userID":130906,"name":"Ivan Perez","url":"https:\/\/community.smartsheet.com\/profile\/Ivan%20Perez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T19:19:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":130906,"lastUser":{"userID":130906,"name":"Ivan Perez","url":"https:\/\/community.smartsheet.com\/profile\/Ivan%20Perez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T19:19:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3343297233,"url":"https:\/\/community.smartsheet.com\/discussion\/98993\/countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98993\/countifs-formula","format":"Rich","lastPost":{"discussionID":98993,"commentID":355135,"name":"Re: COUNTIFS Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355135#Comment_355135","dateInserted":"2022-12-21T19:19:33+00:00","insertUserID":130906,"insertUser":{"userID":130906,"name":"Ivan Perez","url":"https:\/\/community.smartsheet.com\/profile\/Ivan%20Perez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T19:19:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-21T19:19:52+00:00","dateAnswered":"2022-12-21T19:01:27+00:00","acceptedAnswers":[{"commentID":355129,"body":"
