@Diogo_Nogueira - I don’t know of a ‘simple’ solution, but here’s a workaround.
If NOTES is the name of the field you are trying to count words for, try:
LEN(Notes)-LEN(SUBSTITUTE(Notes," “,”"))+1
LEN(Notes) will count the total characters
SUBSTITUTE(Notes," “,”") will remove the spaces from Notes. Wrapping that in LEN will then count the characters in Notes without spaces.
Then we need to add one (1) to this, since the last word won’t have a space after it.
Be aware that if you use a space in the field you are counting, it will effectively tell this formula that there is a separate word.
Hope this helps! :slightly_smiling_face:
