# All New Data Editor & Computed Columns **URL:** \ **Category:** General\ **Created:** [November 3, 2021, 12:54pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964 "2021-11-03T12:54:50Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [November 4, 2021, 12:37pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/41 "2021-11-04T12:37:40Z")
The new Array handling options are incredible! Finally a way to manipulate arrays including a simple way to eliminate an entry within the array. Goodbye Trebuchet it was fun whilst it lasted… ---
**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:** [November 4, 2021, 12:43pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/42 "2021-11-04T12:43:30Z")
Yes, it does work. It has nothing to do with your actual spreadsheet. It uses coding to interpret your Excel formula. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [November 4, 2021, 12:46pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/43 "2021-11-04T12:46:22Z")
Sounds good, but I failed on my first attempt… why doesn’t this work? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f20d54968fd6fb700f6cee4559932165f0d80184.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 4, 2021, 12:54pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/44 "2021-11-04T12:54:23Z")
It probably does handle all Excel formulas, but you can get Today() by creating a math column with a replacement that points to Now. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 4, 2021, 12:57pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/45 "2021-11-04T12:57:00Z")
Formulas must start with = ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [November 4, 2021, 1:32pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/46 "2021-11-04T13:32:16Z")
Ok, but not quite the result I was expecting… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de902091827eb809dfc12d37ee5ce92dd2d24a33.png) vs Excel: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/45e9ce4d2d699bc7b3626fd28588f859722f004e.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:** [November 4, 2021, 1:39pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/47 "2021-11-04T13:39:27Z")
That’s giving you a numerical representation of today, which is actually the same as what Excel does under the hood. You’d need to apply some formatting to it. But as Jeff pointed out, you’re better off just using a Glide Math column for this use case. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 4, 2021, 1:40pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/48 "2021-11-04T13:40:41Z")
I think Google and Excel store that underlying date serial number. The only difference is that they usually have the column formatting applied. Instead I think you would have to do `=TEXT(TODAY(), “m/d/yyyy”) I’d still use a math column for this particular case. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [November 4, 2021, 1:43pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/49 "2021-11-04T13:43:40Z")
Thanks for diving down that rabbit hole with me… appreciate the Glide version is of course the best route… I was just trying an Excel formula and that was the first that came to mind… all those Excel wizards must be feeling smug today! 🙂 ---
**Author:** ![Jim\_McIntosh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_mcintosh/32/19235_2.png) [@Jim\_McIntosh](https://community.glideapps.com/u/Jim_McIntosh)\ **Post date:** [November 4, 2021, 1:44pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/50 "2021-11-04T13:44:08Z")
These new computed columns add a ton of value. Thank you. I can now implement my email validation using Onesimpleapi without setting up the code (very no/low code of you). ![Screen Shot 2021-11-04 at 9.49.57 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d8d8585ab42b5ec2562e2127c8a3097ad090955.png) ---
**Author:** ![Gideon\_Lahav\_Busines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gideon_lahav_busines/32/41121_2.png) [@Gideon\_Lahav\_Busines](https://community.glideapps.com/u/Gideon_Lahav_Busines)\ **Post date:** [November 4, 2021, 5:54pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/51 "2021-11-04T17:54:16Z")
> [@JackVaughan](#): > > New Data Editor Announcement - YouTube Great job 🏆 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [November 4, 2021, 11:30pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/52 "2021-11-04T23:30:29Z")
What @Darren_Murphy are @Jeff_Hager meant by numerical value of a date is that whether in Excel or Google Sheets, dates are but an integer. If you select a column in Excel/GS, format it to date, put a date in any cell of the column, you’ll see the date displayed as a date. Change the format of the same column to number and you’ll get an integer. The origin of the counter is around January 1,1900. Exce vs. Google Sheets trivia: the counters don’t start exactly on the same date. I used to know the exact dates but I don’t anymore. You can test it out in Excel and GS directly 🙂 ---
**Author:** ![kingzy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingzy/32/15690_2.png) [@kingzy](https://community.glideapps.com/u/kingzy)\ **Post date:** [November 5, 2021, 2:30am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/53 "2021-11-05T02:30:04Z")
I spent my holiday playing with the new plugins and it was amazeballs! It really moves no-coding up a notch. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [November 5, 2021, 8:34am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/54 "2021-11-05T08:34:58Z")
My literally exploded now 🤯 This absolutely amazing. Well done team glide 👏👏👏🏆 ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [November 5, 2021, 8:47am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/55 "2021-11-05T08:47:40Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/024631ab2b6c6b27a090084c56008a9ba5a2ba39.jpeg) Right mouse click on any table 🙂 More complex things to play with 🎉 ---
**Author:** ![VVerhille](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vverhille/32/16246_2.png) [@VVerhille](https://community.glideapps.com/u/VVerhille)\ **Post date:** [November 5, 2021, 8:51am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/56 "2021-11-05T08:51:37Z")
Hi, here some feedback for Pluralize Plugin - does not work with 0 value \> should not indicate plural - Use case : could be also with “Complete Plural text” : example : 2 / item / items … could return “2 items” directly without need to implement a “Template column” . Thanks ---
**Author:** ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)\ **Post date:** [November 5, 2021, 9:36am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/57 "2021-11-05T09:36:23Z")
![screenshot-go.glideapps.com-2021.11.05-10-31-29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9e71cd7b3ed410143de7cd691e691c60503d8b7.png) Excellent and super fast QR-CODE management. Instead, it may interest someone how I solved their display, through RT instead of Image or Title. I encoded the base64 via a template. ---
**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:** [November 5, 2021, 11:01am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/58 "2021-11-05T11:01:49Z")
WOW!!! This is incredible. ---
**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:** [November 5, 2021, 11:11am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/59 "2021-11-05T11:11:52Z")
Can anyone confirm that this works for you, or just a selected few have it? I can’t see anything when I right click on the Glide Tables… Thanks in advance! ---
**Author:** ![profxeni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profxeni/32/24656_2.png) [@profxeni](https://community.glideapps.com/u/profxeni)\ **Post date:** [November 5, 2021, 11:20am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/60 "2021-11-05T11:20:26Z")
Idem [Previous page](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964.md?page=2) [Next page](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964.md?page=4)