r/sheets

Filtering a table onto another sheet based on dropdown

I have a table which is essentially an inventory, what I would like is another sheet that only shows me items in the table that have been listed for over 30 days. The key is the dropdown in column G as I would only want this to happen where that is set to "Listed". Then once something is sold and I change that dropdown I would like it to be deleted from the filtered table

I've created a test sheet which shows the table

https://docs.google.com/spreadsheets/d/1v_8cxNmUQqiSgYjKV_X1_06iO1WPVzmIX2kH4aCOImE/edit?usp=sharing

Basically a filter on the table but have it appearing in another sheet so I have on demand access to it

Hopefully makes sense!

u/Significant-Army-502 — 6 days ago

▲ 2 r/sheets

How to use date formulas when I care only about month and year

Have a specific project that needs to compute expiration dates but days are not relevant. Only the month and year is tracked and input into our logs. I need a workaround that computes whether 5 years and 1 year has passed for different input mm/yy dates, and give me a YES or NO for whether the part is in spec.

Example:

Manually input inspection date on part: 02/23

5-year interval in spec: yes 1-year interval in spec: no

What I'm using so far =IF(EDATE(D2,60) - TODAY() > 0, "YES" , "NO")

It doesn't work because the system misreads my input date (02/23) as the 23rd day of February of the current year, not as February of 2023.

How do I set the system to read my month/year inputs correctly? Typing in the full date format (for example: 01/02/23 as day/month/year) is not an option. Any coding behind the scenes to temporarily convert our inputs is though.

reddit.com

u/Capable-Grab5896 — 7 days ago