# Can't change column types

**URL:** <https://community.glideapps.com/t/cant-change-column-types/14325>\
**Category:** Ask for Help\
**Created:** [August 21, 2020, 2:34pm UTC](https://community.glideapps.com/t/cant-change-column-types/14325 "2020-08-21T14:34:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rokner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rokner/32/12277_2.png) [@Rokner](https://community.glideapps.com/u/Rokner)\
**Post date:** [August 21, 2020, 2:34pm UTC](https://community.glideapps.com/t/cant-change-column-types/14325/1 "2020-08-21T14:34:20Z")

</div>

Hello guys,

I have a column in my sheet which uses a formula to calculate some value. I also have a Glide app which can add rows to that sheet. When I add row my formula column is emptied out in the new row and there is nothing calculated. I think I saw somewhere that you can change the column type so it’s a formula but I can’t change any column’s type they are all grayed out. I also don’t have any component or anything in the Add screen which refers to this column. Any help will be appreciated!

---

<div class="post-metadata">

**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:** [August 21, 2020, 2:38pm UTC](https://community.glideapps.com/t/cant-change-column-types/14325/2 "2020-08-21T14:38:47Z")

</div>

To change the column type to what it should be, you can try creating a new column using Glide Editor and copy the old data to the new column, so it should honor the format.

Another way is to try changing the format of the cell on the second row of that column (assuming that’s where the data starts to be filled in). As I understand Glide makes a best guess of the column type based on that cell.

---

<div class="post-metadata">

**Author:** ![Rokner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rokner/32/12277_2.png) [@Rokner](https://community.glideapps.com/u/Rokner)\
**Post date:** [August 21, 2020, 4:48pm UTC](https://community.glideapps.com/t/cant-change-column-types/14325/3 "2020-08-21T16:48:05Z")

</div>

But I need the data in the sheet so new column doesn’t work when it’s with Math column type. And changing the cells didn’t work

---

<div class="post-metadata">

**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:** [August 21, 2020, 5:02pm UTC](https://community.glideapps.com/t/cant-change-column-types/14325/4 "2020-08-21T17:02:58Z")

</div>

I understand you need the data in the Sheet. Do you use arrayformula for that column? Can you share a sample of your data, or the formula you use for that column?

---

<div class="post-metadata">

**Author:** ![Rokner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rokner/32/12277_2.png) [@Rokner](https://community.glideapps.com/u/Rokner)\
**Post date:** [August 22, 2020, 6:22am UTC](https://community.glideapps.com/t/cant-change-column-types/14325/5 "2020-08-22T06:22:15Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/596a49d82a477b72c03d99c5651db353dd6e72f4.png)  
This is an example data. The last column is set to contain the two left elements summed together.  
Now when I make an app with this sheet I want to be able to input A and B and then have A+B be correct. But If i make it A+B is set to an empty cell(if i make it like =IF(A+B\>0, A+B, “”) ) or if it’s just like in the image with zeroes it will place it after all the rows with the formula(zeroes)

---

<div class="post-metadata">

**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:** [August 22, 2020, 9:20am UTC](https://community.glideapps.com/t/cant-change-column-types/14325/6 "2020-08-22T09:20:38Z")

</div>

It should be this in your C1 cell.

```
={"A+B";ARRAYFORMULA(IF(A2:A<>"",A2:A+B2:B,""))}
```

---

<div class="post-metadata">

**Author:** ![Rokner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rokner/32/12277_2.png) [@Rokner](https://community.glideapps.com/u/Rokner)\
**Post date:** [August 22, 2020, 11:50am UTC](https://community.glideapps.com/t/cant-change-column-types/14325/7 "2020-08-22T11:50:27Z")

</div>

This works great thanks a lot!