Grab the numbers in a cell to another column then get their average. Substitute, AVG not working
heyjay
✭✭✭✭✭
I need to get the TC values only and then get their average (to be place on sheet summary).
But it appears that when you try to use replace or substitute, it is converting them to text.
Value and INT can be used, but I tried both and its not working for my sample.
...
Tags:
Best Answer
Answers
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives