# Values not shown in glide table **URL:** \ **Category:** Ask for Help\ **Created:** [July 31, 2022, 5:09am UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636 "2022-07-31T05:09:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\ **Post date:** [July 31, 2022, 5:09am UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636/1 "2022-07-31T05:09:51Z")
Hi Guys! Wanna check how come after I have added a formula in Google Sheet (Arrayformula), the values are not appearing in glidetable? Kindly advise if i need to amend anything on the glidetable? Appreciate and thanks in advance! Luke ![Arrayformula Added in Sheet](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5ed0189f92d295634dbec3602e71386bdb476234.png) ![VALUES NOT SHOWN IN GLIDE TABLE](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e992fac0ceabdcf77a9dbd9c8b8fa58d421aa378.jpeg) ---
**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:** [July 31, 2022, 6:06am UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636/2 "2022-07-31T06:06:35Z")
Have you tried triggering a manual sync? Also, have you considered creating that column directly in Glide using a computed column (probably an if-then-else)? If you do that, then you don’t have to worry about data sync. As a general rule of thumb, it’s always better to use Glide computed columns instead of spreadsheet formulas. ---
**Author:** ![pepewaio](https://avatars.discourse-cdn.com/v4/letter/p/e0b2c6/32.png) [@pepewaio](https://community.glideapps.com/u/pepewaio)\ **Post date:** [July 31, 2022, 6:28am UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636/3 "2022-07-31T06:28:55Z")
HI hi thanks for the prompt reply The values appear after i change the Field type to Text. Aside, can ARRAYFORMULA be used for GlideTable? Why is it better to use glide computed columns instead of speadsheet formulas? ---
**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:** [July 31, 2022, 6:41am UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636/4 "2022-07-31T06:41:51Z")
> [@pepewaio](#): > > The values appear after i change the Field type to Text. ah, yes. I missed that. Using text values in a date/time column won’t work, so what you saw was as expected. > [@pepewaio](#): > > Aside, can ARRAYFORMULA be used for GlideTable? Why is it better to use glide computed columns instead of speadsheet formulas? When you use computed columns, the results are applied to all rows in the table. So essentially they work in the same way as an arrayformula. The biggest advantage of using computed columns is that you eliminate any delays caused by data sync between the client devices → Glide servers → Google Spreadsheet (and back again). Imagine that you ask a user to enter some values, then you do some calculations with those values, and present the result. If you’re using spreadsheet formulas, then there will be a delay of anywhere between several seconds and several minutes before the result is shown to the user. Conversely, when you use computed columns, the calculation happens on the client device and the result is available instantly. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 31, 2022, 2:35pm UTC](https://community.glideapps.com/t/values-not-shown-in-glide-table/45636/5 "2022-07-31T14:35:35Z")
The corresponding if-then-else logic in Glide would be: - If “start” is empty then “No Contract”. - If “expire” is on or after today then “Active”. - Else “Expired”.