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 Green maybe?
Best Answer
-
=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
Answers
-
=IF(AND([% Complete]@row = "1", OR([RA Status]@row = "A", [RA Status]@row = "B")), true)
-
@Hollie Green I was so close. You are the best - I owe you - thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives