Here are ten good alternatives to Google Sheets: 1. Just quick, we won’t get too much into a Google Sheets review in this text, but of course, you know where to find that. We have carefully selected some top 10 names in the tables and sheets game. If you are ready, then so are we, so let us get on with each of these amazing examples of the best Google Sheets alternatives. Here’s our full list of the best Google Sheets alternatives 2022:

Good substitute for Google Sheets if you like templates Top Google Sheets competitor for mobile appsīest alternative to Google Sheets for MacOS Great Google Sheets replacement if you want integrations Good Google Sheets substitute for large business Top open-source Google Sheets alternative If(editedCell.The widely-used spreadsheet app from Google Docs Editors Suite and Google WorkspaceĬheap alternative to Google Sheets if you’re on a budget Var tableRange = 'A2:AQ149' // What to sort. * Automatically sorts the 1st column (not the header row) Ascending.

Here are the two sample scripts I've been working with that haven't produced what I wanted it to. I've read something about the possibility of sorting on change rather then on edit, will this work for me? when I use onOpen, it doesn't sort at all. I've tried using both an onEdit and onOpen approach to the problem, but the onEdit only works when I go in and make manual changes to column D, which is annoying. (and also, I can know what I need to drive out in the morning before opening) And as new entries are made the front page should be updated with the latest numbers. That way I can just write something like '='sheet1'!C2' in order to post the last entry in column 2 which should be the latest entry. The simplest way that I can think of to do this is have the spreadsheet autosort every time a new entry is made so that the last entry is always at the top. The best way I can figure to do this is to setup some basic call functions on the 'clean' front page, but in order to make sure I'm using the latest data I need to ensure that I'm always pointing to the most recent time. The idea is that the person at the remote location can update our stock via a simple online form (using jotform integrated w/ google spreadsheets) and then take the raw data on sheet1 and make a nice looking/organized front page with all the pertinent info plus some basic calculations (re: does this mornings opening stock match yesterdays closing level, etc). I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location.

Connect jotform to google sheets