Count a column from different app

AppSheet AppSheet Q&A
1

Dear friends,
I have a formula which counts unpaid rows in a sheet.
Is that possible to have a count formula for rows from different app?
Thanks in advance.

<<COUNT(SELECT(CN[Amount],[STATUS]=”UNPAID”))>>

2

No.

2 Likes
3

Unfortunately it is not possible to run a formula on something in another app.

However, you can add the sheet as a read only table into your app and use the formula. This can reduce the concerns about someone in your current app modifying the sheet data.

2 Likes
4

Thanks a lot my friend

1 Like