Conditional view depending on date

[mtcsp_test]

Hello,

I am a complete beginner with Appsheets and building anything like this, so apologies in advance for the rudimentary explanation.

I am building an app that has 3 columns:

• A - item ID
• B - use by date (date column)
• C - can be used? (Y/N column)

I want to develop a view that only shows items whose use by date is UP UNTIL TODAY only. So at first I thought, is there a way to automatically make all "Y" columns switch to "N" when the date becomes after today? But I couldn't really imagine how to do it, so instead, maybe something like changing the C column to something like IF([B] < TODAY(), "Y", "N"), then have the only "Y" show up...

However, I keep getting errors so maybe I need to start from scratch. Can anyone tell me how to get a conditional view that only shows items whose date column is before today?

Thanks in advance for the guidance.