@mromaire<\/a>,<\/p>Try this!<\/p>
=IF(RIGHT([xfmr#]@row, 1) = \"X\", \"277\/480\", IF(RIGHT([xfmr#]@row, 1) = \"E\", \"120\/208\", \"120\/240\"))<\/p>
Hope that helps!<\/p>
BRgds,<\/p>
-Ray<\/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":106733,"type":"question","name":"Automated email to assigned people on a spreadsheet for updates","excerpt":"I have a sheet that has multiple lines assigned to different people. I'd like to send an automated email 14 days prior to an event day to update all the lines that are assigned to them. I dont want to use the Request an update workflow because it does it like a form and I really need it to be in a spreadsheet. Is it…","categoryID":322,"dateInserted":"2023-06-21T20:33:52+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T16:22:42+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T16:18:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T17:53:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":37,"score":null,"hot":3374834194,"url":"https:\/\/community.smartsheet.com\/discussion\/106733\/automated-email-to-assigned-people-on-a-spreadsheet-for-updates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106733\/automated-email-to-assigned-people-on-a-spreadsheet-for-updates","format":"Rich","lastPost":{"discussionID":106733,"commentID":381773,"name":"Re: Automated email to assigned people on a spreadsheet for updates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381773#Comment_381773","dateInserted":"2023-06-22T16:22:42+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T17:53:12+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":"2023-06-22T16:18:59+00:00","dateAnswered":"2023-06-22T16:14:09+00:00","acceptedAnswers":[{"commentID":381766,"body":"
The alert will only send them rows that they are listed as assigned to. The entire sheet will not be shown in the email.<\/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":106730,"type":"question","name":"Date function counting","excerpt":"I want to have the system count the number of days from when an item has been approved, and if it has been longer than 7 days without a PO being sent to the customer I want it to send an alert to a person","categoryID":322,"dateInserted":"2023-06-21T19:46:16+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T16:22:21+00:00","insertUserID":158673,"insertUser":{"userID":158673,"name":"Cole Frank","url":"https:\/\/community.smartsheet.com\/profile\/Cole%20Frank","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OBW3ZY9A6WGM\/nM1ZPKC7N3QCF.jpg","dateLastActive":"2023-06-22T16:12:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T17:53:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":null,"hot":3374829517,"url":"https:\/\/community.smartsheet.com\/discussion\/106730\/date-function-counting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106730\/date-function-counting","format":"Rich","lastPost":{"discussionID":106730,"commentID":381772,"name":"Re: Date function counting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381772#Comment_381772","dateInserted":"2023-06-22T16:22:21+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T17:53:12+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\/TE6GEPKH5TAK\/2023-06-21-15-45-24-copy-of-systems-test-26-validation-purchase-requ-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-06-21 15_45_24-Copy of Systems Test & Validation Purchase Requ... - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T17:28:38+00:00","dateAnswered":"2023-06-21T19:50:59+00:00","acceptedAnswers":[{"commentID":381611,"body":"
You can set up a flag type column. The formula to flag rows where there is no sent date but the approval date is more than 7 days in the past would be:<\/p>
=IF(AND([PO Sent Date]@row = \"//www.santa-greenland.com/community/discussion/31701/\", [LN Approval Date]@row< TODAY(-7)), 1)<\/p>
<\/p>
Then you would set up your automation to rn based on when this column gets flagged.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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 in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
