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?
