What is our primary use case?
My usual use cases for AppSheet involve tracking our IT projects and tasks. All the projects of our IT department and all the tasks are tracked under Google Sheets and AppSheet.
Another use case is that when we discuss any particular task or project, we can put a link to that particular task or project and upload the document in Google Drive as well. One Google Sheet serves as a comprehensive master sheet wherein any document related to any project or any task can be found in Google Drive.
What is most valuable?
The features or capabilities of AppSheet that I have found the most valuable include Freeze Panes, which is one of the most valuable features, and Dropdown, which is another valuable feature.
Freeze Panes is extremely important because it freezes the first top row of the sheet. When I'm scrolling the sheet and going down, I can see the first row on the screen full time while scrolling to my data. This is a very beautiful feature of Google Sheets. Additionally, the dropdown feature allows me to write yes, no, and not applicable against a particular line item without typing every time by creating a dropdown. I write it once with yes, no, not applicable, and then I select that option.
The real-time updates in AppSheet improve collaboration in my team because 40 people in the same department operate on a single Google Sheet. They all update their tasks, their projects, and everything on that same sheet, which is a massive leap in technology. Otherwise, I would be mailing a single Excel sheet to 40 people and getting everybody's input from them all manually, which would be extremely time-consuming. It's a massive technology jump when it comes to collaboration.
What needs improvement?
What I think could be improved or enhanced in AppSheet includes the timeline feature, as that is something which is a real pain point and not very efficient in Google Sheets.
For how long have I used the solution?
I have been working with AppSheet for the last five to six years.
What do I think about the stability of the solution?
AppSheet is absolutely stable because even if someone tries to delete any data, I can retrieve it from the edit history. I can also lock the cells, which I have done in AppSheet. When I lock and protect certain cells, I give particular access to those cells to the team member who needs to fill that specific set of cells in Google Sheets.
What do I think about the scalability of the solution?
AppSheet has been scalable in an exponential manner, not just a linear manner. When 40 people are working from the same department on the same sheet, it is quite self-explanatory that this is a very scalable tool.
By linear, I mean if one person is mailing the sheet to another person, then it goes to a third person, which makes it more of a labor-intensive process. In contrast, exponential means that 40 people work together on a single sheet, which is smart work. Additionally, it gives the edit history for each and every single edit made by any individual team member.
How are customer service and support?
I do not often communicate with the technical support of AppSheet as I have not had the need to do that so far.
I usually utilize documentation and guides by accessing Google support, where there is a help section with a lot of articles. From there, I found out about the timeline feature as well. The amount of material is quite comprehensive and sufficient, so there was no need to approach Google support for any feature.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
Before AppSheet, I was struggling with Excel by just mailing Excels to each other and was using MS Project Online. In Project Online, I had access to a document library to share documents with the team, but it was not very user-friendly. AppSheet is much more user-friendly.
Before ending up with Google, we did not evaluate many options. We have Smartsheet, Wrike, ClickUp, and various other tools, but Google Sheets resembles Microsoft Excel in many ways. It is the one where collaboration is the fastest and most comfortable for everybody.
How was the initial setup?
The initial setup process and deployment were relatively very simple. I just had to share the sheet with people and give them edit, view, or commentator rights. It was a very simple process; I just needed their mail IDs to share the sheets and ask them to fill the data while assigning tasks to the team.
What about the implementation team?
I participated in the initial setup of AppSheet as part of the IT department, but dealing with the vendor was not my responsibility. I was part of the setup from the end user's perspective.
What was our ROI?
The biggest return on investment with AppSheet is that 40 people are working on the same sheet, which provides significant ROI in terms of time saving, increased collaboration, and effectiveness. This is the biggest use case of AppSheet.
What's my experience with pricing, setup cost, and licensing?
The pricing and licensing of AppSheet are quite competitive. Even the Google One membership or its plans are quite cheap, so that is not an issue. When compared to the Microsoft Suite of Apps, Google Suite of Apps is far cheaper. Even if I have a personal plan of Google Drive, it is quite pocket friendly.
What other advice do I have?
I have utilized AppSheet's workflow automation by using VLOOKUP.
VLOOKUP is very important because between multiple sheets, VLOOKUP, even in Google Sheets, is very useful. If I'm searching for a single task ID, let's say the name of the task ID is TSK 221681, just a random example, and I come to a new sheet and press Control F to find and search for every single task manually, it consumes a lot of time. That is the reason why VLOOKUP is very handy and useful.
Regarding the integration capabilities of AppSheet, I have not worked on the integration part with other products.
Customizable templates have helped me in application development as they shorten down my work duration and repetitive tasks.
I have not used macros in AppSheet for data collection improvements, but I have used them in Excel.
I have given this review an overall rating of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google