@dsmartsheetuser<\/a> <\/p>Hi Deepthi, try this one...<\/p>
=if([Date1]@row < today(), [Date2]@row)<\/p>
Did that help?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 22:38:25","updateUser":{"userID":99556,"name":"dsmartsheetuser","url":"https:\/\/community.smartsheet.com\/profile\/dsmartsheetuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T22:54:24+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":96959,"type":"question","name":"Dashboard auto color metrics.","excerpt":"Is there a way to auto color metrics (derived from Smartsheet Summary section) percentages on Dashboard ? EX: If the production rate is over the set goal - auto color the percentage number on dashboard to green if not auto color the percentage to red to indicate below goal ?","categoryID":322,"dateInserted":"2022-10-25T14:43:48+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153291,"lastUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3333453079,"url":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","format":"Rich","lastPost":{"discussionID":96959,"commentID":348641,"name":"Re: Dashboard auto color metrics.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348641#Comment_348641","dateInserted":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+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-10-26T00:07:35+00:00","dateAnswered":"2022-10-25T14:59:36+00:00","acceptedAnswers":[{"commentID":348581,"body":"
Can only be done if the metric is coming from a cell (using conditional formatting on the sheet level).<\/p>
This is not available form the sheet Summary<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 00:07:35","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+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":96938,"type":"question","name":"Need help with sumifs statement","excerpt":"I am trying to sum a column in a sheet if one of seven cells contain a matching text string. It is bombing out and I am stuck. The last criteria is to limit the invoice amounts summed to those that are overdue (date before today). Formula =SUMIFS({balance}, {A1}, HAS(@cell, \"alia.bostaji@colliers.com\"), OR({a2}, HAS(@cell,…","categoryID":322,"dateInserted":"2022-10-24T19:32:32+00:00","dateUpdated":"2022-10-24T19:35:57+00:00","dateLastComment":"2022-10-25T20:54:42+00:00","insertUserID":121535,"insertUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":121535,"lastUserID":121535,"lastUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":56,"score":null,"hot":3333375434,"url":"https:\/\/community.smartsheet.com\/discussion\/96938\/need-help-with-sumifs-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96938\/need-help-with-sumifs-statement","format":"Rich","lastPost":{"discussionID":96938,"commentID":348622,"name":"Re: Need help with sumifs statement","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348622#Comment_348622","dateInserted":"2022-10-25T20:54:42+00:00","insertUserID":121535,"insertUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/468U2K8FCTQT\/picture1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-25T15:13:05+00:00","dateAnswered":"2022-10-25T13:43:21+00:00","acceptedAnswers":[{"commentID":348567,"body":"
@Ron Anderson<\/a> <\/p>Try changing to use the CONTAINS function:<\/p>
=SUMIFS({balance}, {combined}, CONTAINS(\"allen wilkerson\",@cell), {invoice date}, <TODAY())<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 15:13:05","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-25T22:39:41+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
她名叫Stara ✭✭✭✭✭✭
Freymish ✭
