Count cells containing text only, excluding text with digits
Options
Salèha El D.
✭✭✭✭✭
Hi,
I need help with a function/formula:
I am looking at counting the number of crew (they are listed by first name) and at the same time exclude any cells with text & digits (names with quantity).
I hope this makes sense  I did some search and cannot find any formula that does the job.
Many thanks,
Thanks,
Salèha
Salèha El D.
Talks about #Smartsheet #productivity, #eventindustry, and #informationtechnology
➖Continuous improvement – for me, an ongoing desire to enhance processes, and increase productivity ➖
Tags:
Answers

@Salèha El D. Is the number always on the right?
If yes:
=COUNTIF(Names:Names, IFERROR(VALUE(RIGHT(@cell, 1)), "OK") = "OK")
If no:
=COUNTIF(Names:Names, NOT(OR(CONTAINS("0", @cell), CONTAINS("1", @cell), CONTAINS("2", @cell), CONTAINS("3", @cell), CONTAINS("4", @cell), CONTAINS("5", @cell), CONTAINS("6", @cell), CONTAINS("7", @cell), CONTAINS("8", @cell), CONTAINS("9", @cell))))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!