Want to practice working with formulas directly in Smartsheet?
Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
❓️Product questions Sign in andask it here!The community's got your back.
Wondering if there’s a problem? Check out theStatus Pageand subscribe for notifications.
=IF([Employer\/Student Agreement Received Date]@row = \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", IF([ESA Sent Date]@row< TODAY(-30), \"Red\", IF([ESA Sent Date]@row<TODAY(-15), \"Yellow\", \"Green\")), \"Green\")<\/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":107678,"type":"question","name":"Automatic Formula in Add Row Workflow","excerpt":"Hello. I have Sheet A which copies the rows to Sheet B once rows in Sheets A have been approved. Sheet A includes a country column and Sheet B includes both a country and region. I would like the region column to automatically generate the region value based on the country value. I have a separate region and country sheet…","snippet":"Hello. I have Sheet A which copies the rows to Sheet B once rows in Sheets A have been approved. Sheet A includes a country column and Sheet B includes both a country and region.…","categoryID":322,"dateInserted":"2023-07-17T16:45:50+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T17:03:01+00:00","insertUserID":163135,"insertUser":{"userID":163135,"name":"JoannaAU","url":"https:\/\/community.smartsheet.com\/profile\/JoannaAU","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T17:03:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DKTEWPYCU2OY\/nBJQNCZXABT0R.png","dateLastActive":"2023-07-18T04:02:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":20,"score":null,"hot":3379227531,"url":"https:\/\/community.smartsheet.com\/discussion\/107678\/automatic-formula-in-add-row-workflow","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107678\/automatic-formula-in-add-row-workflow","format":"Rich","lastPost":{"discussionID":107678,"commentID":385593,"name":"Re: Automatic Formula in Add Row Workflow","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385593#Comment_385593","dateInserted":"2023-07-17T17:03:01+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DKTEWPYCU2OY\/nBJQNCZXABT0R.png","dateLastActive":"2023-07-18T04:02:39+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-17T16:55:04+00:00","dateAnswered":"2023-07-17T16:50:20+00:00","acceptedAnswers":[{"commentID":385587,"body":"