MeganHaro<\/strong><\/a>,<\/p>You can use the below formula for the required condition-<\/p>
=IF(NOT(ISBLANK([Agent Name]@row)), \"Yellow\", \"//www.santa-greenland.com/community/discussion/72529/\")<\/p>
Thank You!<\/p>
Anjanesh Vaidya<\/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":111089,"type":"question","name":"COUNTIF\/S Sheet 2 has \"Auto Doors\" in dropdown","excerpt":"Hello! New to Smartsheet and trying to get a ticketing system going for our FY 2024. I've done a Form already and am working on a metrics sheet for a Dashboard. This is all VERY new to me and I've had no training but I got a subscription and trying to make the best of it. I have Sheet 1 where the Form responses go to. I…","snippet":"Hello! New to Smartsheet and trying to get a ticketing system going for our FY 2024. I've done a Form already and am working on a metrics sheet for a Dashboard. This is all VERY…","categoryID":322,"dateInserted":"2023-10-02T23:07:22+00:00","dateUpdated":null,"dateLastComment":"2023-10-03T05:37:23+00:00","insertUserID":167845,"insertUser":{"userID":167845,"name":"AllyCosenza","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/AllyCosenza","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-03T05:36:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167845,"lastUser":{"userID":167845,"name":"AllyCosenza","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/AllyCosenza","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-03T05:36:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3392600685,"url":"https:\/\/community.smartsheet.com\/discussion\/111089\/countif-s-sheet-2-has-auto-doors-in-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111089\/countif-s-sheet-2-has-auto-doors-in-dropdown","format":"Rich","lastPost":{"discussionID":111089,"commentID":398009,"name":"Re: COUNTIF\/S Sheet 2 has \"Auto Doors\" in dropdown","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/398009#Comment_398009","dateInserted":"2023-10-03T05:37:23+00:00","insertUserID":167845,"insertUser":{"userID":167845,"name":"AllyCosenza","title":"Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/AllyCosenza","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-03T05:36:26+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VA8DQ9REC35N\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-03T05:33:29+00:00","dateAnswered":"2023-10-02T23:22:56+00:00","acceptedAnswers":[{"commentID":397999,"body":"
Hello and welcome!<\/p>
If your Program list in Sheet 2 is written out to match the option in your form and entries in Sheet 2, then you can just reference those for look up:<\/p>
=COUNTIF({Task Request Range 1},=Program@row)<\/p>
Where \"Program\" is the actual column header you have the list Auto Doors, Baler, Compactors, etc.<\/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":111081,"type":"question","name":"Combining selected cells into one cell ignoring blanks?","excerpt":"Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…","snippet":"Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if…","categoryID":322,"dateInserted":"2023-10-02T20:25:16+00:00","dateUpdated":null,"dateLastComment":"2023-10-02T21:09:01+00:00","insertUserID":167760,"insertUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":167760,"lastUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":43,"score":null,"hot":3392562857,"url":"https:\/\/community.smartsheet.com\/discussion\/111081\/combining-selected-cells-into-one-cell-ignoring-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111081\/combining-selected-cells-into-one-cell-ignoring-blanks","format":"Rich","tagIDs":[254,587,590],"lastPost":{"discussionID":111081,"commentID":397984,"name":"Re: Combining selected cells into one cell ignoring blanks?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397984#Comment_397984","dateInserted":"2023-10-02T21:09:01+00:00","insertUserID":167760,"insertUser":{"userID":167760,"name":"toca1","title":"User","url":"https:\/\/community.smartsheet.com\/profile\/toca1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-02T21:06:06+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-10-02T20:53:50+00:00","dateAnswered":"2023-10-02T20:52:20+00:00","acceptedAnswers":[{"commentID":397979,"body":"
@toca1<\/a> Yes, you can do that, or you can create helper columns that grab the text from the cells you want and apply the formula to those instead.<\/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"},{"tagID":587,"urlcode":"join","name":"Join"},{"tagID":590,"urlcode":"collect","name":"collect"}]}],"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":[]}">
Trending in Formulas and Functions
How to update a status color Hi, My goal is to have the status change from blank to yellow once an agent name is added in column 3. How do I do that? Any help would be greatly appreciated! Thank you!
COUNTIF/S Sheet 2 has "Auto Doors" in dropdown Hello! New to Smartsheet and trying to get a ticketing system going for our FY 2024. I've done a Form already and am working on a metrics sheet for a Dashboard. This is all VERY new to me and I've had no training but I got a subscription and trying to make the best of it. I have Sheet 1 where the Form responses go to. I…
Combining selected cells into one cell ignoring blanks? Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…
Ramzi K ✭✭✭✭✭
