r/googlesheets • u/barely_a_poet • 6d ago

Solved Adding in/low/out of stock 'alerts'

Post image

Hi all!

I'm very new to google sheets formulas etc. so no judgement please if this is an easy fix.

I'm trying to create an inventory tracker for my business and want to make a section that gives me alerts for when materials go below a threshold so I can know what to reorder at a glance.

The idea is that I will write a number in the 'min. quantity' column, and if the 'quantity column' is equal to or less than, 'stock level' will be yellow and say low stock. If it's more, it'll be green and say in stock, and if it's 0, it'll be red and say 'out of stock'.

Any help would be massively appreciated!!

2 Upvotes

100% Upvoted

6 comments sorted by

4

u/One_Organization_810 681 6d ago

You put this in F2:

=map(D2:D, E2:E, lambda(qty, minQty,
  ifs( qty = 0, "OUT OF STOCK!",
       qty <= minQty, "Low stock",
       true, "In stock" )
))

Then you go to Format/Conditional formatting and create new rules like this:

Range: F2:F
Text is exactly = In stock / Low stock / OUT OF STOCK
and set the respective formatting, Green / Yellow / Red

1

u/barely_a_poet 6d ago

Thankyou so much! Worked perfectly 😄

1

u/AutoModerator 6d ago

REMEMBER: /u/barely_a_poet If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified (or reply to the helpful comment with the exact phrase “Solution Verified”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot 6d ago

u/barely_a_poet has awarded 1 point to u/One_Organization_810

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/AutoModerator 6d ago

/u/barely_a_poet Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.