Formulas and Functions

= TODAY(), Status@row <>…","categoryID":322,"dateInserted":"2020-07-03T17:41:03+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T21:58:57+00:00","insertUserID":123240,"insertUser":{"userID":123240,"name":"Cindy Doucet","url":"https:\/\/community.smartsheet.com\/profile\/Cindy%20Doucet","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pNDV6W9dreY!nnPWfz8fFP4!6g9JGObStL-","dateLastActive":"2020-07-06T14:38:14+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-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1654,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/69605\/at-risk-flag-triggered-by-upcoming-due-date-and-or-past-due-and-complete-less-than-100","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69605\/at-risk-flag-triggered-by-upcoming-due-date-and-or-past-due-and-complete-less-than-100","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-03T19:20:09+00:00","dateAnswered":"2020-07-03T19:07:16+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}],"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":69601,"type":"question","name":"Contact List Formula","excerpt":"I have a column in a sheet that I named Assigned To. It pulls a contact based off an IF statement dependent on another cell in the sheet. The formula works properly and plugs in the contact appropriately with their icon as well. I have another sheet that pulls together all tasks based on the Assigned To columns. It works…","categoryID":322,"dateInserted":"2020-07-03T16:05:22+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T18:58:37+00:00","insertUserID":123512,"insertUser":{"userID":123512,"name":"Joshua Chesner","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Chesner","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ptHdaRr7vfw!knnRHxyYcj4!mU0QI0BpBsG","dateLastActive":"2020-09-11T12:05:32+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-14T23:41:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":167,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69601\/contact-list-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69601\/contact-list-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-03T18:47:01+00:00","dateAnswered":"2020-07-03T18:46:58+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":69602,"type":"question","name":"If funct quiz","excerpt":"Am trying to solve this query without succeeding please help .if value in cell B is greater than cell A values , divide by 2 and return answer in cell C. if Cell A value is greater than cell B value return A value in C. is the above query manageable.","categoryID":322,"dateInserted":"2020-07-03T16:05:53+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T18:15:37+00:00","insertUserID":123510,"insertUser":{"userID":123510,"name":"heze","url":"https:\/\/community.smartsheet.com\/profile\/heze","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-03T16:06:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":119952,"lastUser":{"userID":119952,"name":"SoS | Dan Palenchar","url":"https:\/\/community.smartsheet.com\/profile\/SoS%20%7C%20Dan%20Palenchar","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u51DN0U3pCQ!!T9BI0iqfVwi","dateLastActive":"2023-07-05T17:30:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/69602\/if-funct-quiz","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69602\/if-funct-quiz","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":69067,"type":"question","name":"Risk Assessment Matrix Summary","excerpt":"Has anyone used the Risk Assessment Matrix template and then created a dashboard summary view? I would like to create a summary like the blow that rolls up all the risks.","categoryID":322,"dateInserted":"2020-06-11T23:50:49+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T14:01:16+00:00","insertUserID":82351,"insertUser":{"userID":82351,"name":"Leann Gibson","url":"https:\/\/community.smartsheet.com\/profile\/Leann%20Gibson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/7e\/c6\/n7ec6db531603daaefab20990ddcfdd53.jpg","dateLastActive":"2023-07-13T01:26:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":27326,"lastUser":{"userID":27326,"name":"sravya.gupta127326","url":"https:\/\/community.smartsheet.com\/profile\/sravya.gupta127326","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u4jDZw7IorQ!0kjMP0nVeRQ!WuE76W9dgff","dateLastActive":"2022-08-02T09:34:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":276,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/69067\/risk-assessment-matrix-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69067\/risk-assessment-matrix-summary","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CQICQMT12MHS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-04T23:48:02+00:00","dateAnswered":"2020-07-03T14:01:16+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":69565,"type":"question","name":"Different timezones and the today function","excerpt":"So, in one of the sheets we are working on, the date for the today function always changes back and forth (a day difference). We think it's because a member of the team has a different timezone so whenever they make changes to the sheet, not relating to the today functions, it changes. We think this because whenever one of…","categoryID":322,"dateInserted":"2020-07-02T08:35:11+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T13:38:49+00:00","insertUserID":123227,"insertUser":{"userID":123227,"name":"Wini","url":"https:\/\/community.smartsheet.com\/profile\/Wini","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-07T01:38:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112161,"lastUser":{"userID":112161,"name":"Peter Harink","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20Harink","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-10T20:48:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":649,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69565\/different-timezones-and-the-today-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69565\/different-timezones-and-the-today-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-03T00:49:37+00:00","dateAnswered":"2020-07-02T11:52:38+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":69580,"type":"question","name":"Use date and status to define RYG balls","excerpt":"Hey all, Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball. If end date is today or later, AND status is not complete or cancelled, green If end date is today -1, AND status is not complete or cancelled, yellow If end date is today -2 or…","categoryID":322,"dateInserted":"2020-07-02T15:54:13+00:00","dateUpdated":"2020-07-02T15:55:56+00:00","dateLastComment":"2020-07-03T10:36:03+00:00","insertUserID":123234,"insertUser":{"userID":123234,"name":"Anna Keeton","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Keeton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gkjWX68EuSY!n_nUH195fj4!XCTDmrFVO5Q","dateLastActive":"2021-12-30T09:04:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":123234,"lastUserID":123234,"lastUser":{"userID":123234,"name":"Anna Keeton","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Keeton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gkjWX68EuSY!n_nUH195fj4!XCTDmrFVO5Q","dateLastActive":"2021-12-30T09:04:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":827,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/69580\/use-date-and-status-to-define-ryg-balls","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69580\/use-date-and-status-to-define-ryg-balls","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2D8TGEHVUPUN\/rag-formula-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"RAG formula.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-07-03T10:32:45+00:00","dateAnswered":"2020-07-02T19:30:47+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":69555,"type":"question","name":"Trying to pull data into a cell from one column based on criteria from another column","excerpt":"Hello everyone, I've built a project schedule and I'm trying to pull only the task that's \"In Progress\" into the parent row of that phase. So basically my formula needs to look at the children in the status row, find the one that states \"In Progress\" and pull the data in the Task column from that same row into another…","categoryID":322,"dateInserted":"2020-07-01T20:55:58+00:00","dateUpdated":null,"dateLastComment":"2020-07-03T02:44:53+00:00","insertUserID":118070,"insertUser":{"userID":118070,"name":"Stacy Calhoun","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Calhoun","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T21:23:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":118070,"lastUser":{"userID":118070,"name":"Stacy Calhoun","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Calhoun","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T21:23:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":1062,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/69555\/trying-to-pull-data-into-a-cell-from-one-column-based-on-criteria-from-another-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69555\/trying-to-pull-data-into-a-cell-from-one-column-based-on-criteria-from-another-column","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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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