Complete the formula to check if a file is shared with anyone.
=IF(COUNTA([1])>0, "Shared", "Private")
The formula counts entries in the 'Shared With' column (B2:B10). If there are names, the file is shared.
Complete the formula to count how many files are shared publicly.
=COUNTIF([1], "Public")
The 'Access Level' column (D2:D20) shows if files are 'Public'. COUNTIF counts those.
Fix the error in the formula to list files shared with 'john@example.com'.
=FILTER(A2:A20, [1] = "john@example.com")
The 'Shared With' column is C2:C20. FILTER uses it to find files shared with John.
Fill both blanks to create a formula that counts files shared with 'edit' permission.
=COUNTIF([1], [2])
Column E (E2:E30) holds permission types. COUNTIF counts cells with "edit" permission.
Fill all three blanks to create a formula that lists files shared with 'view' permission and owned by 'Alice'.
=FILTER([1], ([2] = "view") * ([3] = "Alice"))
Column A has file names, E has permissions, and F has owners. FILTER returns files with 'view' permission owned by Alice.