IF OR Formula
Hello,
I need help with the following formula, it's working, but I need to change "IF(CONTAIN("Invoice#, [Job Description]@row), "INV")
=IF(OR(CONTAINS("Invoice#", [Job Description]@row), CONTAINS("CO#", [Job Description]@row), CONTAINS("Original Contract", [Job Description]@row), LEFT([Job Number]@row, 1) = 1, LEFT([Job Number]@row, 1) = 2, LEFT([Job Number]@row, 1) = 3), "JOB")
I need to modify to if contain "Invoice#" in Job Description row instead display "JOB", display "INV", the formula below is not working:
=IF(OR(CONTAINS("CO#", [Job Description]@row), CONTAINS("Original Contract", [Job Description]@row), LEFT([Job Number]@row, 1) = 1, LEFT([Job Number]@row, 1) = 2, LEFT([Job Number]@row, 1) = 3), "JOB"), CONTAINS("Invoice#", [Job Description]@row), "INV"))
Thank you.
Best Answer
-
If I understand your request. The formula below should work. It first looks for invoice# and put "INV", if false it checks all your other conditions to input "JOB".
=IF(CONTAINS("Invoice#", [Job Description]@row), "INV", IF(OR(CONTAINS("CO#", [Job Description]@row), CONTAINS("Original Contract", [Job Description]@row), LEFT([Job Number]@row, 1) = 1, LEFT([Job Number]@row, 1) = 2, LEFT([Job Number]@row, 1) = 3), "JOB", " "))
Answers
-
If I understand your request. The formula below should work. It first looks for invoice# and put "INV", if false it checks all your other conditions to input "JOB".
=IF(CONTAINS("Invoice#", [Job Description]@row), "INV", IF(OR(CONTAINS("CO#", [Job Description]@row), CONTAINS("Original Contract", [Job Description]@row), LEFT([Job Number]@row, 1) = 1, LEFT([Job Number]@row, 1) = 2, LEFT([Job Number]@row, 1) = 3), "JOB", " "))
-
It work perfect! Thank you very much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!