Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Count a column from different app

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”))>>

Solved Solved
0 3 102
1 ACCEPTED SOLUTION

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.

View solution in original post

3 REPLIES 3
Top Labels in this Space