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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!