IF OR Formula Help!
Hello!
I'm trying to put together a formula in the Posted To field pictured below, to return a result of either "Internal" or "External." The formula I'm using is below.
=IF(OR([Portal Status]@row = "Posted", [ATS Posted]@row = "internal"), "Internal", "External")
This formula returns an "Internal" result but I can't quite figure out how to get it to return an "External" result or a blank result.
What I'm looking to accomplish is the following...
If the Portal Status = Posted AND the ATS Posted = Internal, then the Posted To column should read "Internal"
If the Portal Status = Posted AND the ATS Posted = Careers, then the Posted To column should read "External"
If the Portal Status = Posted AND the ATS Posted = Web Post: Broadbean, then the Posted To column should read "External"
If the Portal Status = Canceled AND the ATS Posted= Internal, then the Posted To column should read "Not Posted"
If the Portal Status = Canceled AND the ATS Posted= External, then the Posted To column should read "Not Posted"
If the Portal Status = Canceled AND the ATS Posted = Web Post: Broadbean, then the Posted To column should read "Canceled"
If the Portal Status = BLANK AND the ATS Posted= BLANK, then the Posted To column should read "BLANK"
Any suggestions are much appreciated. 😊
Best Answers
-
Hi @Beecher2019,
See if this works for you.
=IF(AND([Portal Status]@row = "Posted", [ATS Posted]@row = "Internal"), "Internal", IF(AND([Portal Status]@row = "Posted", OR([ATS Posted]@row = "Careers", [ATS Posted]@row = "Web Post: Broadbean")), "External", IF(AND([Portal Status]@row = "Canceled", OR([ATS Posted]@row = "Internal", [ATS Posted]@row = "External")), "Not Posted", IF(AND([Portal Status]@row = "Canceled", [ATS Posted]@row = "Web Post: Broadbean"), "Canceled"))))
Hope this helps,
Dave
-
Yes! Thank worked, thank you!! Happy Holidays. ☺️
Answers
-
Hi @Beecher2019,
See if this works for you.
=IF(AND([Portal Status]@row = "Posted", [ATS Posted]@row = "Internal"), "Internal", IF(AND([Portal Status]@row = "Posted", OR([ATS Posted]@row = "Careers", [ATS Posted]@row = "Web Post: Broadbean")), "External", IF(AND([Portal Status]@row = "Canceled", OR([ATS Posted]@row = "Internal", [ATS Posted]@row = "External")), "Not Posted", IF(AND([Portal Status]@row = "Canceled", [ATS Posted]@row = "Web Post: Broadbean"), "Canceled"))))
Hope this helps,
Dave
-
Yes! Thank worked, thank you!! Happy Holidays. ☺️
Help Article Resources
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
Check out the Formula Handbook template!