Archived 2015 Posts

You are basically looking for duplicates. Try something like this in a flag type column:<\/p>

=IF(COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, [Due Date]:[Due Date], @cell = [Due Date]@row)> 1, 1)<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107667,"type":"question","name":"How can I see who responded to my approval request, as in who hit the \"Approve\" or \"Decline\" button?","excerpt":"We use Smartsheet at my company to track customer approvals, however the way we have it setup, the approval request gets sent to a Customer Service Representative who then forwards it to the Customer. We want to make sure the Customer is the one who is approving or declining the request and not the Customer Service…","snippet":"We use Smartsheet at my company to track customer approvals, however the way we have it setup, the approval request gets sent to a Customer Service Representative who then…","categoryID":321,"dateInserted":"2023-07-17T15:15:13+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T15:44:29+00:00","insertUserID":163550,"insertUser":{"userID":163550,"name":"Julio Denis","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20Denis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T15:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163550,"lastUser":{"userID":163550,"name":"Julio Denis","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20Denis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T15:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3379216782,"url":"https:\/\/community.smartsheet.com\/discussion\/107667\/how-can-i-see-who-responded-to-my-approval-request-as-in-who-hit-the-approve-or-decline-button","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107667\/how-can-i-see-who-responded-to-my-approval-request-as-in-who-hit-the-approve-or-decline-button","format":"Rich","lastPost":{"discussionID":107667,"commentID":385579,"name":"Re: How can I see who responded to my approval request, as in who hit the \"Approve\" or \"Decline\" button?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385579#Comment_385579","dateInserted":"2023-07-17T15:44:29+00:00","insertUserID":163550,"insertUser":{"userID":163550,"name":"Julio Denis","url":"https:\/\/community.smartsheet.com\/profile\/Julio%20Denis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T15:43:46+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T15:43:53+00:00","dateAnswered":"2023-07-17T15:29:20+00:00","acceptedAnswers":[{"commentID":385571,"body":"

You would need to have it sent directly to the Customer if you wanted to truly ensure it is them clicking the button. Even using a solution to capture historical data as static and pulling in the \"modified\" type column will have the CSR listed because it is assuming whoever is clicking the button is the recipient of the email (assuming it doesn't just record it as \"automation\").<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">