I’m using the app to display internal supply orders and the delivery status as an inline list. Once items are delivered a button is pressed which updates cell values with a timestamp, i would like the order displayed in the list for a maximum of 7 days after date of delivery. How do i go about doing this within the glide app?
I’m unable to format google sheets spreadsheet with an array formula as the orders come in from paperform online form integration and it wont allow any cell formatting.
That working great thanks, only issue is i think it is filtering when the cell is empty as well. Any suggestions on an additional filter to stop this?
Insert an extra condition at the start of your if-then-else column:
- if delivery date is empty, then blank
Is this what you mean by blank? Still cant seem to get it to display
It looks like your Delivery Date column is a basic text column, instead of a date/time column. This has a snowball effect, and so the math column returns a number instead of a date.
So the first thing to do is fix that. Edit that column and change it to a date/time type.
Once you’ve done that, check your ‘date + 7’ column and make sure it is also returning a date.
Then finally, the second condition in your if-then-else column should be using “on or after” - not “equals”. (“on or after” won’t be available at the moment because the source “Delivery Date” column isn’t formatted correctly)
Follow the above, and that should sort it out.
Ok great, i’ve altered that it doesnt seem to be be picking up the it-the-else column filter
In the screenshot you show there, date + 7 in the first row is 13th October, and NOW is 15th October.
As date + 7 is not after NOW, it won’t return true.
Also - use
true (lowercase) instead of
This is working great now, thanks for your help!