Your formula looks correct for counting work experiences. The issue might be that the AI isn't interpreting your prompt clearly enough. [1]
Try being more specific in your description. Instead of "calculate and return the total number of experiences in", try:
- "Count the total number of work experiences"
- "Calculate how many jobs this person has had"
- "Return the number of work experience entries" [2]
If that doesn't work, you can also try our built-in AI tool Sculptor in the top-right corner - it's great for building formulas and workflows quickly. [3] Let me know if using a more specific prompt helps!
If you still need help with counting the total number of work experiences, I’m here to assist you further. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?