Count a column from different app

[Muzekker_Vatan]

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

[Marc_Dillon]

No.

[aneeshatgoogle · 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.

[Muzekker_Vatan]

Thanks a lot my friend