IF with AND and OR statement
I know this has been discussed before and I've read several posts but I'm still having some trouble and I'm sure it's really easy for the experienced folks here. Referencing the diagram I am trying to turn the star column on with the following logic:
If % Complete = 100% AND RA Status = "A" or "B" then turn star on.
I've got the AND working and OR working separately but get error when trying to combine.
Works for 1 item in RA Status (no OR) =IF(AND([% Complete]@row = "1", [RA Status]@row = "A"), true)
Works for the OR =IF(OR([RA Status]@row = "A", [RA Status]@row = "B")
How do I set it up to combine the 100% complete AND RA Status "A" OR "B"
Thanks!
@Hollie Greenmaybe?
Best Answer
-
Hollie Green ✭✭✭✭✭=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
Answers
-
Hollie Green ✭✭✭✭✭
=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
-
@Hollie GreenI was so close. You are the best - I owe you - thanks!
Categories
Is this all built into one complex automation?<\/p>
<\/p>
If so, I suggest breaking it down into multiple smaller automations. That will make troubleshooting much more manageable.<\/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":[]},{"discussionID":107461,"type":"question","name":"How can I send an Approval request for more than 1 person at the same time?","excerpt":"I have a client that I am sending new properties to review. There are two individuals that need to review and then approve or deny. I would like them both to be able to receive that request at the same time and respond at their convenience. Unfortunately when I sent 1 request to both individuals, smartsheets would only…","snippet":"I have a client that I am sending new properties to review. There are two individuals that need to review and then approve or deny. I would like them both to be able to receive…","categoryID":321,"dateInserted":"2023-07-11T18:01:00+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T19:03:18+00:00","insertUserID":162473,"insertUser":{"userID":162473,"name":"Thomas Cox","title":"Realtor","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Cox","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtccRnxrtf749aFVlBXS4Tb3a0jyofNEovd0UqZw=s96-c","dateLastActive":"2023-07-11T18:55:55+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-07-14T20:36:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":3378203058,"url":"https:\/\/community.smartsheet.com\/discussion\/107461\/how-can-i-send-an-approval-request-for-more-than-1-person-at-the-same-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107461\/how-can-i-send-an-approval-request-for-more-than-1-person-at-the-same-time","format":"Rich","lastPost":{"discussionID":107461,"commentID":384685,"name":"Re: How can I send an Approval request for more than 1 person at the same time?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384685#Comment_384685","dateInserted":"2023-07-11T19:03: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-07-14T20:36: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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-12T07:12:31+00:00","dateAnswered":"2023-07-11T18:11:49+00:00","acceptedAnswers":[{"commentID":384662,"body":"
Try setting up two completely separate automations.<\/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&categoryID=321&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":4843,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
