Calculating SUM pending on dropdown selection
I'm trying to calculate a sum pending two different drop down selections but having challenges with making it work. Any help would be greatly appreciated!
=IF(OR(Coverage@row = "Travel", Coverage@row = "Local", Coverage@row = "2 Locations"), (SUM([# of Shifts]@row * 12))), (OR(Coverage@row = "Planning Only"), (SUM([# of Shifts]@row * 6)))
Help Article Resources
Check out the Formula Handbook template!