# Computed Spreadsheet

**URL:** <https://community.glideapps.com/t/computed-spreadsheet/56401>\
**Category:** Ask for Help\
**Created:** [January 6, 2023, 3:34am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401 "2023-01-06T03:34:32Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rian\_Hidayat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rian_hidayat/32/52437_2.png) [@Rian\_Hidayat](https://community.glideapps.com/u/Rian_Hidayat)\
**Post date:** [January 6, 2023, 3:34am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/1 "2023-01-06T03:34:32Z")

</div>

Hi, I want to use computed spreadsheet as shown on a template below

 ![1.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d79f1af76ad08c7dc61ab8bb28c0561f43ce96fe.jpeg)

as you can see the picture has a computed spreadsheet so you can add or subctract some values.

but when I build my app from scratch, I cant find it.

how to enable that features? do I have to make a payment first? or upgrade?

---

<div class="post-metadata">

**Author:** ![Rian\_Hidayat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rian_hidayat/32/52437_2.png) [@Rian\_Hidayat](https://community.glideapps.com/u/Rian_Hidayat)\
**Post date:** [January 6, 2023, 3:35am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/2 "2023-01-06T03:35:13Z")

</div>

![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a4433f8d3553a8fe67e42e7ed0fdc7084e2b507.png)

as you can see, I cant find it if build from scratch

---

<div class="post-metadata">

**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:** [January 6, 2023, 3:44am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/3 "2023-01-06T03:44:25Z")

</div>

You should have access to all computed column types, regardless of which plan you are on.

What do you see if you try it from inside the Data Editor? (click the icon shown below)

 ![Screen Shot 2023-01-06 at 11.42.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6753405a4b2435c4c4a141524dec9cb3c65038d.jpeg)

---

<div class="post-metadata">

**Author:** ![Rian\_Hidayat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rian_hidayat/32/52437_2.png) [@Rian\_Hidayat](https://community.glideapps.com/u/Rian_Hidayat)\
**Post date:** [January 6, 2023, 3:58am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/4 "2023-01-06T03:58:44Z")

</div>

![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d597e27a40390c4123b37f7f13c151f8df7015de.png)

I tried, but I still cant fint the computed menu

---

<div class="post-metadata">

**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:** [January 6, 2023, 4:01am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/5 "2023-01-06T04:01:27Z")

</div>

Okay, one question - do you see this when adding a new column, or are you trying to edit an existing column?

If you’re trying to change an existing column, that won’t work. Once a column is created as a non-computed type, it can’t be changed to a computed type.

---

<div class="post-metadata">

**Author:** ![Rian\_Hidayat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rian_hidayat/32/52437_2.png) [@Rian\_Hidayat](https://community.glideapps.com/u/Rian_Hidayat)\
**Post date:** [January 6, 2023, 4:02am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/6 "2023-01-06T04:02:19Z")

</div>

![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db035a4fc05cf604268e056cea1e73a047adb72c.png)

as you can see, on the template, they have math type or computed spread sheet

how to enable it?

---

<div class="post-metadata">

**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:** [January 6, 2023, 4:03am UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/7 "2023-01-06T04:03:28Z")

</div>

> [@Rian\_Hidayat](#):
>
> how to enable it?

It’s enabled by default.

But please note my previous question & comment.

> [@Darren\_Murphy](#):
>
> Okay, one question - do you see this when adding a new column, or are you trying to edit an existing column?
> 
> If you’re trying to change an existing column, that won’t work. Once a column is created as a non-computed type, it can’t be changed to a computed type.

---

<div class="post-metadata">

**Author:** ![Rian\_Hidayat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rian_hidayat/32/52437_2.png) [@Rian\_Hidayat](https://community.glideapps.com/u/Rian_Hidayat)\
**Post date:** [January 6, 2023, 8:45pm UTC](https://community.glideapps.com/t/computed-spreadsheet/56401/8 "2023-01-06T20:45:22Z")

</div>

oh I see, so I need to make a new column to have computed value. I will try it thanks 🥰

Youre really helpfull man! bless youu
