Cell breaking format

I am formatting a table to score leads, one of the cells will assign a score based on the number of employees. Clearbit returns numbers in the following format ‘1-10’,‘11-50’, etc.

Every combination works EXCEPT ‘1-10’ where the format of the cell changes to a date, breaking the scoring model and returning a date rather than a company # of employees range.

I think this is a bug in Rows…

Help?

Thanks,

Bryce

Hi Bryce,

I’ve provided feedback on the automatic classification of this as a date to the team to investigate.

In the mean-time, you can use this method to get the desired result:

image
Use =TO_TEXT("1-10") for the values

image

Then you can use =SPLIT(A2,"-",0) in the column to the right to automatically split the text by the “-” delimiter.

I hope this helps. If not, let me know and we can dive deeper.