Google Sheets RECEIVED Function: Syntax, Examples & Tips

settlement:
The date when the investment is made or the security is purchased.

maturity:
The date when the investment or security matures or expires.

investment:
The total amount of money invested in the security.

discount:
The discount rate or yield on the investment.

[day_count_convention]:
(Optional) The method used to calculate the number of days between the settlement and maturity dates, which can affect the interest calculation.

What is a RECEIVED Google Sheets Formula?

The RECEIVED formula in Google Sheets is a useful function that helps you track and manage the status of items or tasks that have been received. This formula can be particularly beneficial for inventory management, project tracking, or any scenario where you need to confirm the receipt of items or information.

In simpler terms, the RECEIVED formula allows you to check if specific items have been received and can return a corresponding status or message based on that check.

A Practical Example

Imagine you are managing a shipment of products and you want to keep track of which items have been received:

Shipment Table:

Tracking Table:

You want to fill in the ReceivedStatus column in the Tracking Table based on the Status from the Shipment Table.

RECEIVED Formula

To achieve this, you would use the RECEIVED formula as follows:

=IF(XLOOKUP(B2, Shipment!A:A, Shipment!C:C, "Not Found") = "Received", "Yes", "No")

In this formula:

• B2 is the cell containing the ItemID from the Tracking Table.
• Shipment!A:A is the range where the function will look for the ItemID in the Shipment Table.
• Shipment!C:C is the range from which the function will return the corresponding Status.
• "Not Found" is the value that will be returned if there is no match found.
• The IF function checks if the returned status is "Received" and returns "Yes" or "No" accordingly.

Result of the Formula

When you apply the RECEIVED formula to the Tracking Table, the output would look like this:

In this case, the formula checks the status of each ItemID and indicates whether it has been received.

Why Use RECEIVED?

The RECEIVED formula is beneficial because it streamlines the process of tracking item statuses in your spreadsheets. It allows for quick checks and updates without manually searching through tables. Additionally, it provides a clear visual representation of which items have been received, enhancing your inventory management or project tracking efforts.

Key Takeaways:

• RECEIVED: A practical formula for tracking the status of items or tasks.
• Efficiency: Simplifies the process of checking item statuses, saving time and effort.
• Clear Status Indication: Provides a straightforward way to visualize received items.
• Common Use Cases: Ideal for inventory management, shipment tracking, and project status monitoring.

The RECEIVED formula is an essential tool for anyone managing items or tasks in Google Sheets, providing a powerful way to enhance tracking and reporting capabilities.

Happy tracking!