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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!