Sheet Summary Function not calculating
Is there a data field limit for sheet summary formulas like below? It is working for other columns.
=COUNT(DISTINCT([UAT Test ID]:[UAT Test ID]))
________________________________________________________________________________________________________________________
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Meg Young | Smartsheet Consultant mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration
Comments
-
-
@Paul Newcome no error message. The calculation returns result of 1 and it should be closer to 1,500
________________________________________________________________________________________________________________________
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Meg Young | Smartsheet Consultant mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration
-
How is the data within the range populated? Is it a mix of numbers and letters? Do numbers have leading zeros?
-
@Paul Newcome it is mix of three letters and 4 numbers. Some sheets have 3 numbers and those calculate correctly. There are no leading zeros.
ABC####
________________________________________________________________________________________________________________________
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Meg Young | Smartsheet Consultant mmyoungconsulting@gmail.com. Certified in Core Product, Project Management, and System Administration
-
Ok. It sounds like there may be a mix of data types then. If there are just numbers with no leading zeros, that is stored as a number, but the letters on the front of some are stored as text strings. We need a consistent data type to evaluate.
Insert a text/number column and use this column formula:
=[UAT Test ID]@row + ""
(that's a plus quote quote there on the end)
Then try referencing this helper column.
Help Article Resources
Categories
Check out the Formula Handbook template!