How to sum financial data.

I have 3 columns - labor cost, parts cost, vendor cost - each as a 'Price' column type.

I have a 4th column 'Total Cost' where I want to sum all costs. I tried inputting expression below into 'Total Cost' app formula to no avail.

SUM(LIST([Labor Cost], [Parts Cost], [Vendor Cost])

Seems like I'm missing something simple.. Any help is appreciated!

Post has attachment
I made workflow email triggered when adding new row
what is the expression that makes when the added row contains "person1" in a specific column send email to ""
thanks in advanced.

could u tell me if i can find an existing sample apps that shows how to show a filtered gallery...
I ve got two tables :
Table 1

Table 2

Would like display Table 1 & Table 2 with gallery view
At the opening, TaBle 1 in gallery (Pic1 to Pic4 ) and when I select the Pic1 => that open a new galery with pic11 to pic 41...

Pls thx for your help and the name of sample apps

Hi guys,

I'm wondering if someone can please give me a bit of insight into an issue I'm having.

I have a form which an address can be added to, which then displays on a map once the record is complete. I'm using the suggestions which come up in the address field to select the address (which looks like Google Maps suggestions?). I'm finding issues when it comes to plot these on the map, it appears the map might be a Bing Map? Bing doesn't seem to recognise some localities suggested by Google in the form, so will plot the location somewhere else (even outside NZ, when the address includes NZ funnily enough!). Searching the address in Bing gives another locality which when put into the app form, plots it in the right location.

Is there some way of managing this to have the selected address come from the map? The function will be great if it works this way!


I am working on a time keeping app. In one table I am storing all time sheet information to include each pay cycle and pay period. I also have a table where I am referencing the date of time sheet entry to collect each cycle or period.

I am trying to create two slices where I can view time sheet information for the current pay cycle and pay period.

I have not been able to come up with a reference between the two tables to compare values. Any suggestions?

I would like to create a Menu or a button, that once selected a report is generated.
The report should be a print out of all the rows of a specific table (with few reference tables) in a PDF.

I assume I can do that with scheduled Report, but I do not want per a given schedule, I would like the user to have an option to create it when needed.
Is there a way to do that?

Hi I am putting 6 forms into one table and view using an app column and #control... etc. If I dont want my form views in the menu should I use Show if false or set the form views as ref?

Why isn't a shared folder on OneDrive visible as a shared folder?

When I try to add a new data source in AppSheet and choose OneDrive, it only lists Documents, Pictures and one other folder I created in the account. However when I log into the same OneDrive (personal) account on line, it includes another folder in my Files too. That other folder is not one I own but one that has been shared with me by another user who has given me the ability to edit files in that folder. Why isn't it visible in AppSheet so I can connect to it?

is there any way filtering data in datasheet view ? i would like to filter data like an excel filter

I realize a lot of you are doing really complex stuff with Appsheet. One day I'll get there too. But can I tell you a little story of a simple app that maken a few people really happy?
My children are in a band (Pip Blom) and they're touring a lot. I see them leave the house with a tour schedule on paper and I thought that can be done better!
I built a simple app with Appsheet where they have all the important information about the gigs, the travels and the hotels in an app. And where they can directly mail or phone or message to venue or hotel if needed, where they can look up the location and go to Google Maps if needed, etcetera.
That is very handy for them.
But while they were on tour we thought: shouldn't all the merchandise information be in the app too? So while they were in Newcastle I added a tab to the Google Sheet in Amsterdam. Now they only have to enter the amount of records, cd's and t-shirts they have sole on a day and the app tells them the total sales in money for that day and for the whole tour.
This makes them happy too .... It's that flexibility I like so much about Appsheet and the fact that you can make an app for only 4 people ....
Great word, Appsheet people!
Wait while more posts are being loaded