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.
My Smartsheet has a form with form logic - users select the Team they are requesting support from, and then the logic provides the appropriate Staff column for that Team. I would like to copy the contact from these columns into the Requested EHSN Staff column on the same row. The goal is to then hide all of the separate…
I have to ask as I am hitting a wall here. I want to create a resource/solution where people can claim things : The work flow consists of Two parts. Section A and Section B. Section A (completed already) Section A is form where User A fills up to show/post what's available to claim from recently added items which I will…
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…
