Formula for Count unique values
Is there any formula to count unique cell values? I will use this for docs dashboard.
Zoomtopia is here. Unlock the transformative power of generative AI, helping you connect, collaborate, and Work Happy with AI Companion.
Register nowEmpowering you to increase productivity, improve team effectiveness, and enhance skills.
Learn moreKeep your Zoom app up to date to access the latest features.
Download Center Download the Zoom appDownload hi-res images and animations to elevate your next Zoom meeting.
Browse Backgrounds Zoom Virtual BackgroundsEmpowering you to increase productivity, improve team effectiveness, and enhance skills.
Zoom AI CompanionUser groups are unique spaces where community members can collaborate, network, and exchange knowledge on similar interests and expertise.
Help & Resources is your place to discover helpful Zoom support resources, browse Zoom Community how-to documentation, and stay updated on community announcements.
The Events page is your destination for upcoming webinars, platform training sessions, targeted user events, and more. Stay updated on opportunities to enhance your skills and connect with fellow Zoom users.
Is there any formula to count unique cell values? I will use this for docs dashboard.
Hello Zoom team and community, I’d like to request two enhancements for Zoom Docs that would significantly improve document security, data governance, and collaborative workflows: It would be extremely helpful to have the option to password-protect individual documents. This feature would allow creators to restrict access even if a link is shared more widely than intended, adding an extra layer of security for sensitive or confidential information. Key benefits: Prevents unauthorized access via leaked or forwarded links Adds an additional access-control layer beyond workspace permissions Helps organizations comply with internal security policies and external regulations For teams that use data tables within Zoom Docs, the ability to set role-based permissions at the record (row) level would be transformative. This means different users or user groups could have restricted visibility or edit rights on specific rows. This would enable: Confidential or sensitive rows to be visible only to authorized roles Controlled editing rights to reduce errors or unauthorized changes More flexible workflows for HR, finance, operations, research, and client-based work Improved data governance without needing separate documents or tables These enhancements would make Zoom Docs a stronger fit for organizations that handle sensitive information while still leveraging the collaborative structure of Zoom’s ecosystem. Password protection addresses document-level security, while record-level permissions enable fine-grained control inside shared documents, providing a more enterprise-ready experience. Thank you for considering these suggestions. I’d love to see Zoom Docs evolve with stronger permission controls, and I’m happy to provide additional context or use cases if helpful.1. Password Protection for Zoom Docs
2. Record-Level Permissions for Data Tables
Show less
1. Reason for Rollup Reference Limitations in Formulas & Future Support Roadmap Is the current inability to reference a Rollup column within a Formula (resulting in a #REF! error) an intended architectural decision designed to prevent performance bottlenecks (e.g., cascade updates) or circular dependencies? We would appreciate clarification on the technical reasoning behind this limitation. Furthermore, are there ongoing optimizations to address this, and if so, when can we expect this feature to be supported in your roadmap? 2. Schedule and Roadmap for Zoom Data Table API Re-release Access to Zoom Data Table API endpoints is essential for our external automation and system integration plans. Could you please share the specific schedule or roadmap regarding when the Zoom Tables API will be re-released or made officially available to developers?
Show less
Hi, I'm trying to set up a project plan in Zoom Data Tables, and can't find a way to make dependent tasks. For example, if row 1 had an end date of 10/10/25, I would want to make the next row's start date of 10/11/25. Is there currently a way to configure this, or would this be a feature request?
Show less
Is there a fix to print a clean-looking Zoom document with a header that includes a data table?
I've printed and distributed a PDF with a data table from Zoom Docs on Chrome for the past four months. Recently (last week), the data table has been pushing itself 1 page down from where the header of the document is. No matter what I try, using different web engines, computers, deleting cookies, or changing print settings (page size, borders, scale, etc.), nothing seems to work. To add to this, the new PDF export also doesn't support data tables.
If anyone has a workaround for printing a PDF with a data table, I'm all ears.
All I know is that it was working two weeks ago, and now it's not.
Show less
A field type that could be added to Zoom Docs data tables that would dramatically increase its viability would be a lookup field. A lookup field that references a related table to automatically populate values. Users can select a record from a related dataset, and the lookup field will fetch and display a specified field (e.g., name, ID, status) from that linked record. This enables dynamic relationships between tables, reduces data entry duplication, and ensures data consistency across documents. Currently, when you create a relation, it displays the text of the primary field, but it would be beneficial if you could choose any field from the related data table.
Show less
I have synced my data tables but now just want to keep the originals.
But when I delete a synced table I will also delete the original, it seems.
Is there a safe way to delete a synced data table? I know that in Notion you can un-snyc them. But I do not see that option here.
Show less
I wrote a guide to using ZOOM Docs using Docs. The whole document is set on commentary but no editing for viewers. I inserted a whiteboard, which I set to editing. This works fine. People cannot edit the document, but they can edit the whiteboard, as intended. I did the same with the forms-view of the table, wanting people to be able to fill out a form with predefined questions in my document. I have this published and set to "everyone with link can answer" but people CAN'T ANSWER. I'm talking about this view: If I set the document to edit (which is not an option, just for testing's sake), people still can't answer the questions, they can only edit them. What do I have to do, to get people to be able to answer the questions? Edit: I got it. Forms need a separate Link to share with users, they are apparently not intended to be integrated in usable form in a document. I improvised by embedding the correct link in my document. I leave this here in case others are confused. Also, maybe it would be an idea to simplify using forms in documents, the same way it is done with whiteboards?
Show less
Currently, resolved comments are page-wide, but I would like to see an option in the record view of a data table to view resolved comments specific to that record. Can someone from the Zoom team chime in and let me know if this feature is in the works or I'd be happy to discuss if additional information is needed. Zoom Docs has the potential to be one of Zoom's best products imo and I see that new features are quickly being implemented which I appreciate.
Show less
Whenever I group by date, whether its year or by month it is ALWAYS one behind. So if the date is 9/15/2024 and I have it grouped by month, the date above it will show "August 2024," and if i have it grouped by year, the date above will show "2023."
Show less