Template store - can the sheet have formulas?

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.

1 Like

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.

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.

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

Thanks for your comment.

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

2 Likes