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.

[lynchk21]

You can either 1) create a 'slice' on the table that filters out all rows where [B]<=TODAY() and then use that 'slice' for your view. 2) If you want to use a formula in your [C] column to generate a 'Y' or 'N' you can use IF([B]<=TODAY(),TRUE,FALSE). 3) If you want to change the [C] column based on the date, you can set up a scheduled bot to run daily that updates any values in the [C] column that is TRUE to FALSE when the date in [B]<=TODAY()

[mtcsp_test]

Thank you for your help!

I was able to do the first step, but I realize I made a mistake with my question. Instead of TODAY, I need to show rows where [B] is at least a month before today. May you help me with the expression for that? Thanks so much.

[lynchk21]

If an approximate value will work, you can just subtract 30 from TODAY():

• [B]<=TODAY()-30