Currently we have 2-3 full names in cell & I need to calculate the total number of people in a cell e.g. currently the cell contains variations such as, Sam Smith & Jon or Sam Smith, Jon Smith.
Is that column a text column? Or connected?
Hey @Nomac - you can use the following formula:
LEN({Text}) - LEN(SUBSTITUTE({Text}, " ", ""))
{Text} is the name of the column.
Hope this helps!
Mark
Hi Theresa, assuming it’s a text column, you could do a custom AI prompt to "count the number of names in the {column name} column. It sounds like the problem to be solved is the data quality itself though, so perhaps the capture of this data could be enhanced to ensure it comes into the board in a consistent way. Otherwise, I’d just update the AI prompt to account for the data quality anomalies. Give it a try and let me know how you go.
