Giving an output based on text from multiple selection dropdown
Good Afternoon,
I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date "Finish Start." Both columns are on the same sheet, even though the "Processes" column pulls from another sheet.
Currently, I've been seeing multiple uses of an If/Then formula with "Contains" in it. It seems like the right solution, it's just not giving me a result. This is my current formula =IF(CONTAINS("FAB - Finish",[email protected], 3, 0))
Best Answer
-
Kelly Moore ✭✭✭✭✭✭
Hey@Ross Conley
Try this
=IF(CONTAINS("FAB - Finish",[email protected]), 3, 0)
If you have multiple words to add that have different values, delete the zero and parenthesis and add additional IFs after the 3,
Does the formula above work for you?
Kelly
Answers
-
Kelly Moore ✭✭✭✭✭✭
Hey@Ross Conley
Try this
=IF(CONTAINS("FAB - Finish",[email protected]), 3, 0)
If you have multiple words to add that have different values, delete the zero and parenthesis and add additional IFs after the 3,
Does the formula above work for you?
Kelly
-
Kelly,
Thank you so much! This fixed it 100%.
When I read the solution, I facepalmed so hard that I fell out of my chair. For those that are rereading it 3 times like I did, the position of your parenthesis ")" are extremely important. I've grown accustom to excel autocorrecting the formulas and didn't realize.
Help Article Resources
Categories
Hi @jwilson<\/a> <\/p> I hope you're well and safe!<\/p> Try something like this.<\/p> Edited because I was thinking of a cross-sheet range.<\/p> Try this.<\/p> =IFERROR(MONTH([Actual Submission Date]@row), \"//www.santa-greenland.com/community/discussion/105755/\")<\/p> Did that work\/help?<\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"},{"commentID":389540,"body":" Are you using the Month and Year columns simply as a way to pull out that information to fill in the MM\/YYYY column? If so, you can eliminate those columns entirely and directly pull the data into the MM\/YYYY column.<\/p> =IFERROR(IF(MONTH([Actual Submission Date]@row) < 10, \"0\", \"//www.santa-greenland.com/community/discussion/105755/\") + MONTH([Actual Submission Date]@row) + \"\/\" + YEAR([Actual Submission Date]@row), \"//www.santa-greenland.com/community/discussion/105755/\")<\/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":108640,"type":"question","name":"Finding the earliest date for each vendor","excerpt":"I have a list of contracts that need to be audited periodically. I want to put a column into the list that will show the earliest date required to do the audit based on the vendor and contract expiration dates. In other words, if Vendor A has 10 contracts with expiration dates over the next 5 years, what is the earliest…","snippet":"I have a list of contracts that need to be audited periodically. I want to put a column into the list that will show the earliest date required to do the audit based on the vendor…","categoryID":322,"dateInserted":"2023-08-07T20:52:58+00:00","dateUpdated":null,"dateLastComment":"2023-08-08T19:57:18+00:00","insertUserID":163500,"insertUser":{"userID":163500,"name":"Celia Gust","title":"Senior Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Celia%20Gust","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hKjqoZ4ULCo!oTjdKGolkCc!l8VPIb9Jvnz","dateLastActive":"2023-08-08T15:58:29+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-08-08T20:02:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3382968016,"url":"https:\/\/community.smartsheet.com\/discussion\/108640\/finding-the-earliest-date-for-each-vendor","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108640\/finding-the-earliest-date-for-each-vendor","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108640,"commentID":389598,"name":"Re: Finding the earliest date for each vendor","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/389598#Comment_389598","dateInserted":"2023-08-08T19:57:18+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-08-08T20:02:03+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\/6O73V26D3AIV\/screenshot-2023-08-07-134222.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-08-07 134222.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-08T15:48:27+00:00","dateAnswered":"2023-08-07T21:42:48+00:00","acceptedAnswers":[{"commentID":389378,"body":" You will need a MIN\/COLLECT like so:<\/p> =MIN(COLLECT([Expiration Date]:[Expiration Date], Vendor:Vendor, @cell = Vendor@row))<\/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"}]}],"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":[]}">
