# Visibility within a week of timestamp **URL:** \ **Category:** Ask for Help\ **Created:** [October 14, 2021, 10:46am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061 "2021-10-14T10:46:17Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [October 14, 2021, 10:46am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/1 "2021-10-14T10:46:17Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 14, 2021, 10:54am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/2 "2021-10-14T10:54:55Z")
- Create a Math column with the formula `Date + 7`, where date is the delivery date - Create a 2nd Math column with just the formula `Now`, and substitute that with the “Now” special value - Now, create an if-then-else column: - if first math column is on or after second math column, return `true` - else blank - Filter your inline list to show only those rows where the if-then-else column is `true` ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [October 14, 2021, 11:39am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/3 "2021-10-14T11:39:32Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 14, 2021, 11:43am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/4 "2021-10-14T11:43:47Z")
Insert an extra condition at the start of your if-then-else column: - if delivery date is empty, then blank ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [October 15, 2021, 8:40am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/5 "2021-10-15T08:40:25Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4afc587bf614d0173e61da65a3560db7f4339ea0.png) Is this what you mean by blank? Still cant seem to get it to display ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2021, 9:07am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/6 "2021-10-15T09:07:12Z")
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. ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [October 15, 2021, 9:43am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/7 "2021-10-15T09:43:43Z")
Ok great, i’ve altered that it doesnt seem to be be picking up the it-the-else column filter ![Screenshot 2021-10-15 10.40.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de799ca668834f84a27f23685baa0859e1b34afb.png) ![Screenshot 2021-10-15 10.41.52](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3ae02cf07eb5a732acd3570441eebe6e15b85a24.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 15, 2021, 9:49am UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/8 "2021-10-15T09:49:20Z")
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 `TRUE` ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [October 25, 2021, 12:44pm UTC](https://community.glideapps.com/t/visibility-within-a-week-of-timestamp/33061/9 "2021-10-25T12:44:22Z")
This is working great now, thanks for your help! 👍