This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am wanting to create a virtual column in one of my tables where the
value of the virtual column is the MAX of one of the columns in the
reference list in the same table.My Customers table has a reference list
for calls made to the customer, I want ...
Hi GuysI was wondering whether it is possible to generate a daily email
report that goes off each day and includes some chart / dashboard views
from the app? Triggering an email is the easy part, but including this
graphical data either in the email ...
Hi GuysI have two tables for counting stock, STOCK COUNT and STOCK COUNT
DETAILS. The stock count table creates a new entry every time out staff
perform a stock count at a customer, the details table is linked to the
stock count table but contains th...
Hi Guys I’m wondering if anyone has had experience with using a Google
Sheets All On like https://apipheny.io/ They seem to have a GREAT system
to parsing information from 3rd party APIs directly into Google Sheets
and can get() and post() data from ...
Hi Guys Is there a formula within appsheet to create a new barcode / QR
Code? My workflow would be for the user to view an item or location, and
if there is no barcode then for appsheet to automatically create one
that can then be printed. Thanks!
Ok, I understand. Our system / user input assumed that if there are no
values for a brand then it is "zero" so we are not counting zero. Is
there any way to work this logic into the formula you have given?
Hi @Suvrutt_Gurjar Thanks again for your assistance here, but I'm not
getting the correct result still...I have confirmed the column names are
correct in the formula, apologies for my error here. See below the image
showing what I require on the left...
Hi @Suvrutt_Gurjar not sure if you saw my reply: @Suvrutt_Gurjar I tried
your formula but it did not seem to work as I intended. See below an
image of the data table:I would NOT want to show the lines highlighted
in RED as you will see at the bottom ...
@Suvrutt_Gurjar I tried your formula but it did not seem to work as I
intended. See below an image of the data table:I would NOT want to show
the lines highlighted in RED as you will see at the bottom of the image
in BRICHT GREEN there is a more rece...
@Suvrutt_Gurjar yes so there would be multiple lines for each QTY [QTY]
of product [Brand] counted at a given company on the same day [Date].In
some instances, there would be multiple days [Date] for the given
company, in which instance I would only ...
