Incorrect Argument

I am having problems with this formula

This is a reservation system for multiple locations. Each location has a different number of space available. I am trying to write a formula that will calculate the current number of spaces available based on the number of different bookings and give you a most current updated spaces available for each location.

This is what I have so far, but it's not working out:

=IF(MIN([Date Booked]:[Date Booked]=[Location]@row,[Spaces Available]@row-[Spaces Needed]@row,[Spaces Available]@row))

Find more posts tagged with

Accepted answers

All comments

NickStaffordPM

Hello!

So the MIN function you are using is not being used correctly. This is used to ID the smallest number within a set(MIN(Value 1, Value 2, Value 3), but you have it looking at an entire column ([Date Booked]:[Date Booked], equal to the location ([Location]@row), and not closed (two closed parenthesis at the very end).

Lets work through this, where are you trying to write this formula - a cell or within the sheet summary?

dmayers85007

within a cell:

NickStaffordPM

Are all columns you need to reference included within this one sheet?

dmayers85007

Yes

Humashankar

Interesting observation

Humashankar

Valuable perspective

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.