How to Combine these formulas
I posted yesterday about a grid that I have since revamped. I am super new at this and spent a lot of time trying different formulas and watching videos. The formulas are working as standalones but I am having trouble when combining them. Standalone Formulas:
=IF(Type@row = "Medium", WORKDAY([R Date]@row, +10))
=IF(Type@row = "Large", WORKDAY([R Date]@row, +15))
=IF(Type@row = "Small", WORKDAY([R Date]@row, +5))
Combined formula (which is not working and just displays blank as you see in the red cell below):
=IF(CONTAINS(Type@row = "Small", WORKDAY([R Date]@row, +5)), IF(CONTAINS(Type@row = "Medium", WORKDAY([R Date]@row, +10)), IF(CONTAINS(Type@row = "Large", WORKDAY([R Date]@row, +15)))))
What am I doing wrong?
Answers
-
The CONTAINS function doesn't work as you've written it. It's not CONTAINS ( field = something), it's CONTAINS (search_for, range)
As an individual formula it would be written like this:
=IF(CONTAINS("Small",Type@row), WORKDAY([R Date]@row, +5))
As a combined nested IF formula it would be this:
=IF(CONTAINS("Small",Type@row), WORKDAY([R Date]@row, +5) , IF(CONTAINS("Medium",Type@row), WORKDAY([R Date]@row, +10), IF(CONTAINS("Large",Type@row), WORKDAY([R Date]@row, +15) )))
-
This was extremely helpful. I tried to find the different scenarios for IF Contains and this formula worked, it just needed brackets in the type@row section. Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!