How to Calculate the Number of Days Between Two Dates in AppSheet? Calculating the number of days between two dates is a common requirement in many applications, whether it’s for tracking project timelines, managing maintenance schedules, or calculating the time between events. In AppSheet, this task can be accomplished with
How to Manage Salesmanwise Customer Data on Google Sheets: A Step-by-Step Guide Managing customer data in a sales-driven environment requires efficiency, organization, and ease of access, especially when dealing with a diverse team of salespeople. Google Sheets, with its flexibility and built-in automation capabilities, offers a powerful solution for organizing
How to Extract Unique Non-Blank Values in Google Sheets: A Step-by-Step Guide Google Sheets is a powerful tool, but some simple tasks can be unexpectedly tricky. A common challenge is extracting unique values from a column while ignoring blank cells. In this blog, I’ll explain why the UNIQUE function alone isn’t enough, and how to
How to make a Dispatch Management System in Google Sheets: Example, Workflow, Process & Formula As someone who deeply enjoys leveraging technology to streamline business processes, I recently embarked on an exciting project. A medicine distributor approached me, needing help managing their complex dispatch operations efficiently. They were juggling numerous
How to fill formula down in Google Sheets without dragging or Copy Paste!! We’ve all been there. You write a formula in one cell—maybe a VLOOKUP, an IF, or a simple calculation—then copy it down for 200 rows. It works, until… You insert a new row and the formula doesn’t
How to Extract Only Numbers from Text Fields in Google Sheets Using REGEXEXTRACT and ARRAYFORMULA? Sometimes your data comes messy — like “42 Nos”, “205 Nos”, “1 Nos”, and you just want the pure numbers. Manually cleaning each line? Not happening.Luckily, Google Sheets gives us a super clean way to fix it in
How to restrict access to AppSheet App Based on Office Hours? In a recent project, I had to build an inventory management app for a warehouse. The challenge was straightforward: I needed to restrict access to the app so that it could only be used during office hours — from
How to Prevent Duplicate Item Entries Inside a Parent-Child Form Relationship in AppSheet? When building apps in AppSheet, one of the most common challenges in a parent-child form setup is avoiding duplicate entries.Recently, while creating an Expiry Management System for a Medicine Distributor, I faced this issue. The setup had
How to Remove 'sum' from Headers in QUERY Results in Google Sheets? When working with Google Sheets, one of the most useful formulas for summarizing large data is QUERY. It allows you to group, filter, and calculate totals without using Codes and Pivot Tables, which are often too clumsy. However, there’s a small issue that often shows up —When you use SUM() inside a QUERY, the output header
Parent — Child Relationship How to Create a Parent-Child PDF Layout in AppSheet (With Real Example) Recently, I was working on an inventory workflow where a receipt record had multiple items. The challenge? I wanted a PDF layout where the receipt header appears on top, and the child items are neatly shown in a table below. Sounds simple,
