Formula - Extra help w/ a COUNTIFs formula that takes into account when booking from same location

I have a smartsheet that calculates the cost of equipment when its being booked by a garage.
Everything is working well, except my formula is calculating the cost when the equipment is booked by the same garage.
Example shown below:
Equipment: Bobcat Wooster is being booked by the garage called "Wooster". So in this case the transportation cost should be zero. It should be zero because the equipment is booked by the same garage. So there is no transportation cost in this case.
I believe my problem is coming from the column "Count Times Booked by Different District".
The formula for that column is the following:
=COUNTIFS({Equipment}, EQUIPMENT@row, {Status}, "Booking", {Approval Status}, "Approved", {Home Base = Request Garage}, 0)
I'm wondering how can I rewrite this formula to have it equal a "0" instead of a "1" when the equipment is booked by the same garage.
Answers
-
Disregard, I believe I found the issue and solution. The column I was referencing named "Home Base = Request Garage" was missing its formula that auto checks a box. This was being done on another sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!