I have multiple names in one cell and no fixed list of names as if whose names will be there in the new entry and want to count unique names. How to do that using countif ?
@Govinda Is there a screenshot example of the cell? Trying to determine if the column is Contact List or Text/Number as well as the entry format.
Hi Erin, it is Text/ Number and entry is received from a from which will be filled by other people so that they can add multiple names in the Name entry.
I have been using Smartsheet for a few years primarily focused on a I.T. PMO scope, however I recently changed into the education space supporting a K-12 environment. Though I am in the I.T. department, the project support extends to the entire campus and all departments. For those that have been in education with a longer…
In the face of budget constraints and the enrollment cliff, higher education institutions are seeking innovative solutions to maintain operational efficiency. Join us for a transformative webinar that explores how Smartsheet can help you overcome these challenges by optimizing workflows and automating manual tasks. 📅 Event…
I've tried several times now to upload a .csv file into data table. I'm using data shuttle and have no filters selected. The .csv file has 50,123 rows and 1,761,908 cells. I've tested this now a couple of times and it inconsistently pulls in different rows. One time 36,444 and another time 32,577. Have I exceeded data…