# Template store - can the sheet have formulas?

**URL:** https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071
**Category:** Ask for Help
**Created:** [December 19, 2020, 9:22am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071 "2020-12-19T09:22:47Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### 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: [December 19, 2020, 9:22am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/1 "2020-12-19T09:22:47Z")

</div>

I’m considering selling my App in the template store. However, I read in the guidelines that the Google sheet should not contain formulas. The calculations should be done in the App.

Is that true without exception? My app conforms to this but I have a a couple of basic formulas, eg a second Worksheet imports from cells elsewhere in the work book.

Thanks in advance.

Simon.

---

<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: [December 19, 2020, 10:03am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/2 "2020-12-19T10:03:03Z")

</div>

I’m not entirely sure about that, I was under the impression that only scripts & HTML/CSS are not allowed, along other things like sensitive info etc.

---

<div class="post-metadata">

### 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: [December 19, 2020, 10:07am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/3 "2020-12-19T10:07:16Z")

</div>

Well the formula’s are pretty basic ones. Things like

={Sheet1!A2:A}

or

=filter(‘sheet 1’!A1:G,‘sheet 1’!A1:A\<\>"")

Regards,  
Simon.

---

<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: [December 19, 2020, 10:09am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/4 "2020-12-19T10:09:09Z")

</div>

I don’t think that’s gonna be a problem at all.

---

<div class="post-metadata">

### 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: [December 19, 2020, 10:22am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/5 "2020-12-19T10:22:52Z")

</div>

Thanks for your comment.

Can anyone else with experience selling App templates confirm it’s true?

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 12, 2024, 2:03am UTC](https://community.glideapps.com/t/template-store-can-the-sheet-have-formulas/20071/6 "2024-01-12T02:03:39Z")

</div>